Data Validation

[vijaylnyadav]

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

[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 😀👍

[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

[AngelosPachis]

Hi @vijaylnyadav 

You can do that with a Find & Replace tool, as shown below:

Your output would look like this

[atcodedog05 · Accepted solution]

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 😀👍

[atcodedog05]

Happy to help 🙂 @vijaylnyadav 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂