Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
You need a , after the *
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.
I corred the syntax errors still not working
LOAD *,
@1:3 as [Rep-Off],
@4:6 as [Cur-Cd],
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);
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