Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Error In Script


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

Tags (1)
1 Solution

Accepted Solutions

Re: Error In Script

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

5 Replies
simondachstr
Valued Contributor III

Re: Error In Script

You need a , after the *

maleksafa
Valued Contributor

Re: Error In Script

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.

Not applicable

Re: Error In Script

I corred the syntax errors still not working

LOAD *,

     @1:3  as [Rep-Off],

     @4:6 as [Cur-Cd],

MVP
MVP

Re: Error In Script

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

Re: Error In Script

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

Community Browser