remove duplicate from load files

[Voyager]

I have two versions from inventory file which has the same fields name but different record. how could I remove duplicated values between both files. my target is to identify new and deleted records between old and the new version

I have tried load distinct as below but final result came as combined values of both files I think its due to version field 

LOAD 

Distinct

[@1:13] as book#, 

     [@14:18] as type, 

     [@19:n] as unknown,

    Mid(FileName(),17,4) as version

[MayilVahanan · Accepted solution]

Hi 
Try with

'Not exists()" functionality. 

[Prem0212 · Accepted solution]

You can use where not exist condition Data load editor.

i think this will work for you.