Data validation in two columns

Hello Experts,

I am sharing the data of two columns where I am doing the validation. Column "code" data may get repeated "n" number of times. In next column we have "Migrated Code". Our expectation is we should have a unique but same for all "code", repeated value as per column "code" value in Migrated Code", then it will be a match in next validation column. In case If Code has 2 different migrated code, then this is a mismatch. Could you Pls suggest how to build the workflow for this.

Screenshot 2026-03-09 165859.png

Data validation.xlsx

Alteryx Editions

Accepted answers

Qiu

@akhukla
We can use the MultiRow Formula tool with grouping by "Code" to generate Flag if the last row is same value with current row.

0309-akhukla.yxmd

All comments

Qiu

@akhukla
We can use the MultiRow Formula tool with grouping by "Code" to generate Flag if the last row is same value with current row.

0309-akhukla.yxmd

JosephSerpis

Using a combination of Sort tool and Multi-Row Formula can help achieve your desired results

Screenshot 2026-03-09 115932.png

Multi_Row_09032026.yxmd

PeterGoldey

Hi, there is a simpler method.

1. Use a summary tool to Group By "Code" and CountDistinct on "Migrated Code"

2. Join back to the original file on "Code"

3. With a formula tool create your "Validation" value IIF([CountDistinct] = 1, "Match","Mismatch)

Kottapally_Ramesh

Hi Akhilesh,

Attached is the workflow to validate two columns' data - Code vs Migrated Code.

Data validation.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703