Error In Script

[#1]

Hi Friends

I imported a fixed length record file into Qlikview by using Edit Script Tab. It ran properly while importing. But when I am trying to reload its showing error.

LOAD *

     @1:3  as Reporting Office,

     @4:6 as [Currency

     @7:8 as Org,

     @9:10 as Manager etc

FROM

(fix, codepage is 1252, no eof);

It showing error as

Syntax error, missing/misplaced FROM:

LOAD *

Thanks

pavan

[simondachstr]

You need a , after the *

[maleksafa]

can you upload your document, because definitely this will not work as you have missing ',' on the second line after [Currency and the last label should be [] as well.

[#4]

I corred the syntax errors still not working

LOAD *,

     @1:3  as [Rep-Off],

     @4:6 as [Cur-Cd],

[maxgro]

comma and [] for field names with spaces

LOAD *,

     @1:3  as [Reporting Office],

     @4:6 as [Currency],

     @7:8 as Org,

     @9:10 as Manager

     // etc

FROM

(fix, codepage is 1252, no eof);

[ashfaq_haseeb · Accepted solution]

Hi, try below

LOAD *

     [@1:3]  as [Reporting Office],

     [@4:6] as [Currency],

     [@7:8] as [Org],

     [@9:10] as [Manager]

FROM

(fix, codepage is 1252, no eof);

Regards

ASHFAQ