You could accomplish this by adding a new column Client_ID2 to your table which would be a copy of the Client_ID field, but renamed so that you could refer to it later on.
Then, by using the Exists(Client_ID2, Client_ID) condition, you'll be able to apply your desired filtering.
Once you are done with your load, you can remove the extra column by using the Drop Field instruction as such:
DROP Field Client_ID2;
Hi Jacobs, the Where Not Exists should work in the above. Please find the below.
LOAD Clinet_ID , Clinet_ID AS Client_A INLINE [
LOAD Clinet_ID , Clinet_ID AS Client_B
Where Not Exists (Clinet_ID)
LOAD * INLINE [
In the above script, the Client_ID have: 1 2 3 4 5
for testing, Please make sure that don't keep all the fields are are same.