Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ta
You need to end your Load statements with semicolons ;
HIC
Thank you! I should be more careful next time