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 · Accepted solution]

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...

[paulyeo11]

Hi Sir

you spot my mistake.

i think some time ago i accidently create a main 109. as now i already at 127 tab.

and today i accidently paste at main 109 :-

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

after i comment the line it now working fine.

many thank. yes is messy, but it work.  good night.

Paul

[#4]

it happens to the best of us. Could you accept my answer as correct?

Have a nice day.

[paulyeo11]

Hi sir

Yes you deserve more then correct , I will tick tomorrow morning. As after

discover the problem I already log out ? And my iphone safari cannot log in

to tick .

Paul Yeo

TDS Technology (S) P/L

www.tdstech.com

HP +6593261804

[paulyeo11]

Hi Wall

I just found out that why , below script appear at main 109 :-

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

This is before i add Currency script , i accident create a new Tab main 109 , and i copy the above script from before main 109 by Tab last line . so it will not create any error. because it is a continous script.

when i add new Tab before main109 , now the error will occur.

finally i found it.

Paul