I get error msg , which i unable to know what mistake i make.

[paulyeo11]

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

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          '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

CONCATENATE

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          SOURCE,

          EXCHANGE,

          EXCHANGE_

FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT\QSNP_2009.xls (biff, embedded labels, table is [RATE$])

Concatenate

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          '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

CONCATENATE

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          SOURCE,

          EXCHANGE,

          EXCHANGE_

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

[#2]

silly question, did you put an ";" at the end?

[paulyeo11]

Thank you for your reply. may i know where ?

[#4]

try like this, take note of where I have added ";"

CONCATENATE

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          SOURCE,

          EXCHANGE,

          EXCHANGE_

FROM $(vINPUTPath)$(vFile12).xls (biff, embedded labels, table is [RATE$]);

Concatenate

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          '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;

CONCATENATE

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          SOURCE,

          EXCHANGE,

          EXCHANGE_

FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT\QSNP_2009.xls (biff, embedded labels, table is [RATE$]);

Concatenate

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          '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;

CONCATENATE

LOAD

          left(FileBaseName(), 4) AS TDS,

          date_t as date,

          SOURCE,

          EXCHANGE,

          EXCHANGE_

FROM C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT\QSNP_2009.xls (biff, embedded labels, table is [RATE$]);

[paulyeo11]

Hi Sir

you refer to this line of script , at the end need to add :it is ?

FROM $(vINPUTPath)$(vFile12).xls (biff, embedded labels, table is [RATE$]);

[#6]

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

[paulyeo11]

Hi Sir

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 ?

Paul

[paulyeo11]

Hi Sir

Enclosed is my script , look for Tab = currency

Paul

[#9]

CONCATENATE

LOAD

    left(FileBaseName(), 4) AS TDS,

    EXCHANGE_       

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

[paulyeo11]

Hi Sir

I try to min the script in order to isolate the error.

I check your reply , and my code 100% same.

Paul