Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cedfoning
Contributor III
Contributor III

Difference between 2 files

Hello, 

i need some help. 

I have 2 files. 

FileA : 9 000 000 lines

FileA_ID

FileB : 8 000 000 lines. 

FileB_ID

 

I want to have the ID that in FileA that does'nt exists in FileB

 

 

Need your help please

Labels (2)
2 Replies
vamsee
Specialist
Specialist

Try 

FileB:
NoConcatenate
Load 
ID
From FileB;

FileA:
NoConcatenate
Load 
ID
From FileA
Where Not Exists(ID)
;
Drop Table FileB;


vamsee
Specialist
Specialist

If you want to list all and create a flag try 

FileB:
NoConcatenate
Load 
ID
From FileB;

MapFileA_ID:
Mapping Load 
ID, 'Available in  File A' As Flag
From FileA
Where Not Exists(ID)
;
FileB_Transform:
NoConcatenate
Load
ID, 
Applymap('MapFileA_ID', ID, 'Not Available in File A') as Flag_ID
Resident FileB;
Drop Table FileB;