How to identify if values are matching in the fields

Hi Alteryx Community,

I’m working on an impact analysis where Dataset A (Legacy) with 10 fields was upgraded to Dataset B (Revamp). Most of the changes were in field names, but there’s also a possibility that the values in those fields may have changed.

Out of the 10 fields, I know that 4 were renamed, and the remaining 6 have the same names in both datasets. I want to compare the values in each corresponding field (legacy vs revamp) to check if they are the same or have changed. I have the fields names of both datasets along with information of what field from Legacy is changed to what field name in revamp.

The dataset is quite large, so I’m looking for an efficient and scalable approach to perform this comparison in Alteryx. Has anyone tackled a similar scenario? Would love to hear your suggestions or best practices!

Datasets

Accepted answers

Gaurav_Dhama_

To quickly check if values have changed, concatenate all the row per column, and compare the concatenated values.

if values are unchanged, they will match, else you will get false.

now what is the quick way to concatenate?

use transpose to convert all your columns to rows,

now you mist have name and values.

add a cross tab, header by name, and values by values.

method, concatenate.

All comments

jrlindem

So long as the fields are in the same order you can use the Field Info tool to do a quick comparison on the field names. Beyond that, and I'm sure there are a multitude of ways this can be handled but simply using a series of formulas to compare the two like-fields, for differences, and summing up the findings (1's vs 0's) could help narrow down the discovery and tracking. Scaling really wouldn't be an issue here unless the tables your comparison are constantly changing and/or are extremely wide (many columns).

Gaurav_Dhama_

If you are using 2025.1 version of alteryx, under developer tools, you will have equal tool. That does exactly what you want to do.

Gaurav_Dhama_

To quickly check if values have changed, concatenate all the row per column, and compare the concatenated values.

if values are unchanged, they will match, else you will get false.

now what is the quick way to concatenate?

use transpose to convert all your columns to rows,

now you mist have name and values.

add a cross tab, header by name, and values by values.

method, concatenate.

NaveenaJaliparthi

Sure, thanks. I was initially thinking of using flags (1 or 0) to indicate matches—specifically, if Field A in one dataset matches Field B in another, then return 1, otherwise 0. However, I’m wondering if there’s a more efficient or streamlined approach than manually setting up this comparison for each field across both datasets.

Is there a quicker method in ALteryx to handle this kind of comparison?

NaveenaJaliparthi

Unfortunately, we’ll need to stick with the 2023 version of Alteryx to stay compatible with our Gallery version (also 2023). So any solution would need to work within that constraint. But thanks for the info. appreciate it

Gaurav_Dhama_

Attached workflow will give you an idea how you can check. I have added multiple scenarios in it for your reference.

Change Identifier.yxmd

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703