topic Re: Field Not Found Error in QlikView

Field Not Found Error

Anonymous — Sun, 14 Feb 2016 10:43:07 GMT

I have the following load script:

I get a field not found error on loading but the field exists in the data file, what could be the problem:

Re: Field Not Found Error

Chanty4u — Sun, 14 Feb 2016 10:52:52 GMT

hi,

set HidePrefix='_';

and reload again

Re: Field Not Found Error

Chanty4u — Sun, 14 Feb 2016 10:58:03 GMT

in appymap line u hve used field name as record only u cn replce that to _record

Re: Field Not Found Error

Anonymous — Sun, 14 Feb 2016 11:12:16 GMT

Many thanks suresh, i have tried your recommendation and still get the same error message.

Re: Field Not Found Error

Anonymous — Sun, 14 Feb 2016 11:13:36 GMT

Changed to _record in applymap and still get the same error message.

Please find attached app

Re: Field Not Found Error

Chanty4u — Sun, 14 Feb 2016 11:26:21 GMT

u can load that original file and reload again....

orelse

replace

record as [New record]

and reload again

Re: Field Not Found Error

marcus_sommer — Sun, 14 Feb 2016 11:33:58 GMT

You could get such error-messages if your file-format isn't correct - maybe because the delimiter isn't a comma or the file is in an utf-8 format and not ansi or something similar.Take again the file-wizard and look if you then see any differences and check if there are no typos.

- Marcus

Re: Field Not Found Error

Anonymous — Sun, 14 Feb 2016 11:49:10 GMT

Thanks Marcus, using the file wizard helped. The file format was wrong.

Regards.

Chris

Re: Field Not Found Error

Anonymous — Sun, 14 Feb 2016 11:49:44 GMT

Thanks Suresh, the file format was wrong

Re: Field Not Found Error

sfatoux72 — Sun, 14 Feb 2016 11:58:36 GMT

Have you identify if the problem come from:

the second line : record as _record
14th line : ApplyMap('MapDeathToRecord', record, null()) as _death
both

Re: Field Not Found Error

sfatoux72 — Sun, 14 Feb 2016 11:59:43 GMT

Ok, to late