Garbage after statement

Thu, 13 Feb 2014 21:17:59 GMT

Hi,

I'm trying to load following scripts in Qlikview and keep on getting Garbage after statement. Please help!

Garbage after statement
AML:
LOAD
     LONG_DATE,
     METRIC_NAME,
     METRIC_VALUE,
     BUSINESS_RULE_CALC,
     ROOT_CAUSE,
     REMED_PLAN,
     COMPL_TARGET_DATE,
     SECTOR,
     BUSINESS,
     REGION,
     COUNTRY,
     IF(COUNTRY <> 'United States', COUNTRY) AS [Non_US],
     IF(COUNTRY = 'United States', COUNTRY) AS US,
     USER_ID,
     USER_NAME,
     LAST_UPDATE,
     N_A_INDICATOR

FROM
QVD\AML.qvd
(qvd)

AML_Source:
LOAD Period_End_Date,
     Country_Code,
     SAR_ID,
     Sector,
     Primary_Business_Line,
     Secondary_Business_Line,
     Transaction_Monitoring_Number,
     Transaction_Count,
     Currency,
     Transaction_Value,
     Primary_Transaction_Type,
     Secondary_Transaction_Type,
     Primary_Scenario,
     Secondary_Scenario,
     Involves_Cross_Border,
     Primary_Highest_Risk_Geography,
     Secondary_Highest_Risk_Geography,
     Primary_Filing_Reason,
     Secondary_Filing_Reason,
     Date_Investigation_Escalated,
     Date_Investigation_Completed,
     Date_Regulatory_Filing,
     Primary_Product,
     Secondary_Product,
     Involves_AML_Activity,
     Involves_Terrorist_Financing,
     Involves_Remote_Deposit_Capture,
     Involves_Mobile_Banking,
     Involves_Pre_Paid_Cards,
     Involves_Trade_Finance,
     Product_Category,
     Product_Category_If_Other,
     Product_Type,
     Product_Type_If_Other
     Referral_Source,
     Referral_Source_If_Other,
     Description,
     [Additional Comments],
     [Item Type],
     Path

FROM
QVD\AML_Source.qvd
(qvd)

Thank you!

Jasmine

Re: Garbage after statement

hic — Thu, 13 Feb 2014 21:22:26 GMT

You need to end your Load statements with semicolons ;

HIC

Re: Garbage after statement

Thu, 13 Feb 2014 21:27:55 GMT

Thank you! I should be more careful next time

topic Re: Garbage after statement in QlikView

Garbage after statement

Re: Garbage after statement

Re: Garbage after statement