Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I just add the below code to my existing QV doc , which is working fine for 3 yr.
CONCATENATE
LOAD
left(FileBaseName(), 4) AS TDS,
date_t as date,
SOURCE,
EXCHANGE,
EXCHANGE_
FROM $(vINPUTPath)$(vFile12).xls (biff, embedded labels, table is [RATE$]);
when i run with out above script , it work fine , upon adding , i get below error msg :-
Syntax error, missing/misplaced FROM:
Concatenate
'ADL' as SOURCE,
AutoNumberHash128(date_t,'ADL') As Link_Supply_Key,
EXP AS EXP_1,
GP_C as GP_C,
sales_target_s*GP_C as G_PROFIT,
(sales_target_s*GP_C)-EXP as N_PROFIT,
sales_target_s as sales_target_s
FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT\QSNP_2009.xls (biff, embedded labels, table is [RATE$])
after a while i also get below error msg :-
Unknown statement
FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT\QSNP_2009.xls (biff, embedded labels, table is [TDSID_TAR$])
can some one tell me where likely the mistake i make ?
Paul
Lol it's very messy. Look on your tab "MAIN109" you have this
FROM $(vINPUTPath)$(vFile12).xls (biff, embedded labels, table is [TDSID_TAR$]);
Why is that there? This will error out...
View solution in original post
silly question, did you put an ";" at the end?
Thank you for your reply. may i know where ?
try like this, take note of where I have added ";"
sales_target_s as sales_target_s;
FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT\QSNP_2009.xls (biff, embedded labels, table is [RATE$]);
Hi Sir
you refer to this line of script , at the end need to add :it is ?
Yup. After every LOAD statement, you should add an ";", not just the one you gave in your previous response.
upload your qvw and I can add this for you.
Message was edited by: wallerjc
i don't think this is the issue , as before your reply , this script ijust post have : on it , and i am aware of ;
any way i can check for this error beside here , where can it occur ?
Enclosed is my script , look for Tab = currency
FROM $(vINPUTPath) + $(vFile12).xls (biff, embedded labels, table is [RATE$]);
you have two variables, but you're not "joining" them. I have used a + in the above example
I try to min the script in order to isolate the error.
I check your reply , and my code 100% same.
