duplicate values are being duplicated using Join of 2 columns

Question

I am trying to join 2 columns (Previous_Value and New_Value) to be able to compare any added or removed values. Here is an example of a data set:

Previous_ValueNew_Value12211221122112211221122112231221455612235997122384814556 5997 7485

When I do a join from a Record ID, I get the follow output:

Previous_ValueNew_Value1221122112211221122112211221122112231223122312234556455659975997Null74858481Null

But since I am trying to compare what has been removed/added between the 2 columns, I want it to display like this:

Previous_ValueNew_Value122112211221122112211221Null122112231223Null12234556455659975997Null74858481Null

so I can filter for the "Null" values. Any ideas how to make this work?

ChrisK51815 · Answer

Thank you. That worked.

apathetichell · Answer

split data stream - new value - tile tool - unique new value.

previous value - tile tool - unique tile tool.

join -> previous value->new value and tile_seq_number to tile_sequence number

union all anchors.

fix your fieldtypes so they are all the same too.