655048_en-US

liliconcom

Selecting duplicates from different source columns

Hello,

 

I'm trying to select (and delete) duplicates after combining two data tables with a source column, I have 2 criteria for a selection:

-The duplicate values should match in 2 columns (Match :col1, :col2), works fine.

-The duplicate values should not have the same value in the generated source column.

 

I'm not sure how I can code the 2nd criterium, is there some simple != line or 'does not' match ':Source Table'?

 

dt1 << concatenate (dt1, dt2, append to first table(1), Create Source Column ) ;  
dt1 << Select Duplicate Rows (Match (:col1, :col2)) ;

dt1 << Delete Rows();

Data Blending and Cleanup