I’d like to compare two files and output a ‘diff’ file of the rows in File A that are not in File B based on the value of 2 or 3 fields (columns). I’ve been experimenting with a way to do this but have not found a solution yet. I thought I’d post a question here to see if you have a recommendation.
Thank You
You should be able to use the Concat Cols transform to create a new composite key column in each of the A and B datasets. Then you can use the Subtract transform to find values of the composite key column values in A but not in B.