topic Error In Script in QlikView

Error In Script

Tue, 09 Sep 2014 08:17:10 GMT

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

Re: Error In Script

simondachstr — Tue, 09 Sep 2014 08:19:18 GMT

You need a , after the *

Re: Error In Script

maleksafa — Tue, 09 Sep 2014 08:19:49 GMT

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.

Re: Error In Script

Tue, 09 Sep 2014 08:27:58 GMT

I corred the syntax errors still not working

LOAD *,

@1:3 as [Rep-Off],

@4:6 as [Cur-Cd],

Re: Error In Script

maxgro — Tue, 09 Sep 2014 08:31:59 GMT

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

ashfaq_haseeb — Tue, 09 Sep 2014 08:34:47 GMT

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