Field Not Found Error

[Anonymous]

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:

[Chanty4u]

hi,

set HidePrefix='_'; 

and reload again

[Chanty4u]

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

[Anonymous]

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

[Anonymous]

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

Please find attached app

[Chanty4u]

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

orelse

replace

record as [New record]

and reload again

[marcus_sommer · Accepted solution]

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

[Anonymous]

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

Regards.

Chris

[Anonymous]

Thanks Suresh, the file format was wrong

[sfatoux72]

Have you identify if the problem come from:

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