Load complement of a file wit NOT EXISTS

[draghici1109]

Hello,

I want to load complement of a file using the following code:

UOE:

NoConcatenate

LOAD FeldUOEA 

from [00-08121000-40-100-AlleOrgEinheiten.txt](txt,delimiter is '|');

Concatenate(UOE)

LOAD OrgEinheitExcluded

FROM [00-08121000-40-100-UngueltigeOrgEinheiten.txt](txt,delimiter is '|')

Where not Exists (FeldUOEA, OrgEinheitExcluded)

;

STORE UOE into from [00-08121000-40-100-UOE.qvd](qvd);

drop table UOE;

EXIT SCRIPT;

i got the errror:

Field not found error

Field 'FeldUOEA' not found

UOE:

NoConcatenate

LOAD FeldUOEA 

from [..\DATA\00-08121000-40-100-AlleOrgEinheiten.txt](txt,delimiter is '|')

I do not have a clue, why I get this error.

Thank you in advanc

File content: 00-08121000-40-100-AlleOrgEinheiten.txt

FeldUOEA|Fueller
30000000|F
30000052|F
30000285|F
30000286|F
30000287|F
30000288|F
30000289|F
30000293|F
30000294|F
30000295|F
30000296|F
30000297|F
30000298|F
30000299|F
30000300|F
30000333|F
30000334|F
30000335|F
30000336|F
30000337|F
30000384|F
30000385|F
30000405|F
30000407|F
30000408|F
30000409|F
30000410|F
30000411|F
30000412|F
30000443|F
30000445|F
30000446|F
30000447|F
30000467|F
30000468|F
30000469|F
30000470|F
30000471|F
30000505|F
30000523|F
30000528|F
30000529|F
30000540|F
30000541|F
30000549|F
30000550|F
30000725|F
30000748|F
30000749|F
30000792|F
30000809|F
30000840|F
30000857|F
30001044|F
30001925|F
30002582|F
30002632|F
30002633|F
30002634|F
30002636|F
30002637|F
30002638|F
30002639|F
30002640|F
30002642|F
30002643|F
30002644|F
30002645|F
30002646|F
30002647|F
30002648|F
30002649|F
30002700|F
30002701|F
30002702|F
30002703|F
30002704|F
30002705|F
30003102|F
30004151|F
30004305|F

File content: 00-08121000-40-100-UngueltigeOrgEinheiten.txt

OrgEinheitExcluded|Fueller
30000285|F
30000288|F
30000296|F
30000299|F
30000334|F
30000407|F
30000408|F
30000409|F
30000410|F
30000411|F
30000412|F
30000443|F
30000445|F
30000446|F
30000447|F
30000505|F
30000523|F
30000528|F
30000529|F
30000540|F
30000541|F
30000549|F
30000550|F
30000748|F
30000749|F
30000792|F
30000809|F
30000857|F
30001044|F
30001925|F

[Cascader]

try:

UOE:

NoConcatenate

LOAD FeldUOEA 

from [00-08121000-40-100-AlleOrgEinheiten.txt]

(txt, delimiter is '|', msq);

[draghici1109]

well, it seems that I get the same error message:

Field not found error

Field 'FeldUOEA' not found

UOE:

NoConcatenate

LOAD FeldUOEA 

from [..\DATA\00-08121000-40-100-AlleOrgEinheiten.txt]

(txt, codepage is 28591, embedded labels, delimiter is '|', msq)

[Cascader]

both load statements work fine in my windows 10 env.!

looks like something related to PC?

[marcus_sommer · Accepted solution]

I suggest that you use the table-wizard to get the right load-statement - means let Qlik identify the file-format and the file-content. Maybe the txt is stored with utf8 or a similar file-format and has a BOM ...