topic Re: duplicate values are being duplicated using Join of 2 columns in Alteryx Designer Desktop Discussions

duplicate values are being duplicated using Join of 2 columns

ChrisK51815 — Tue, 10 Sep 2024 17:32:01 GMT

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:

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

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

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

apathetichell — Tue, 10 Sep 2024 18:09:25 GMT

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.

ChrisK51815 — Tue, 10 Sep 2024 21:12:53 GMT

Thank you. That worked.