Find only new information?

Hi, I need to know the best way to set this up. I have two columns of numbers. I need the end result to be what the differences are in those two columns of numbers. Thanks

Do you mean numbers that are in column 1, but not in column 2? Split it into 1 dataset and use Subtract.

Or do you mean the difference from subtract each value of column 2 from the column 1 value on the same row? use Calculate.

Or something else? An example might help.

Hi,

Hope this covers all your scenarios

image

Transform file
NumbersInTwoColumns.transform (4 KB)

3 Likes