Data Validation

Column1	Column2	Column 3	Column 4
XYZ	1	XYZ1234	01
ABC	2	ABC4322	04
MNO	3	MNO2341	06

Consider a sample data,

Here, i want to compare column3 & column4 with Column1 & column2

For Eg,

number in column 2 should match with number with column 4 condition is that string in column1 should match with first 3 letter in Column3.

If ABC = 2 then ABC4322 should be equal to 2 (not 4) considering the relation with ABC = 2.

Please suggest some solutions

Datasets

Accepted answers

atcodedog05

Hi @vijaylnyadav

Here is a workflow for the task.

Output:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

match.yxmd

All comments

philipmannering

Hi @vijaylnyadav

You can refer, and reply, to @AngelosPachis comment here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Data-Validation/td-p/672165

atcodedog05

Hi @vijaylnyadav

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

match.yxmd

vijaylnyadav

Column1	Column2	Column 3	Column 4
XYZ	1	XYZ1234	01
ABC	2	MNO2341	04
MNO	3	ABC2341	06

Consider a sample data,

Here, i want to compare a specific data not the whole column.

For Eg,

If ABC = 2 then ABC4322 should be equal to 2 (not 6) considering the relation with ABC = 2 and if MNO = 3 then MNO2341 should be equal to 3 (not 4) without sorting the columns.

Please suggest some solutions

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703