Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
draghici1109
Creator
Creator

Load complement of a file wit NOT EXISTS

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
 
 
Alexandru Draghici
BICC at Komm.ONE
Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

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 ...

View solution in original post

4 Replies
Cascader
Creator
Creator

try:

UOE:
NoConcatenate
LOAD FeldUOEA 
from [00-08121000-40-100-AlleOrgEinheiten.txt]
(txt, delimiter is '|', msq);

 

draghici1109
Creator
Creator
Author

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)
Alexandru Draghici
BICC at Komm.ONE
Cascader
Creator
Creator

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

looks like something related to PC?

marcus_sommer

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 ...