Data Validation

[vijaylnyadav]

Roll No	Key	Value	Test Key	Test Value
101	AA	01	EE1111	04
102	BB	02	AA1111	01
103	CC	03	JJ1111	07
104	DD	04	DD1111	02
105	EE	05	GG1111	07
106	FF	06	JJ1111	10
107	GG	07	GG1111	06
108	HH	08	CC1303	03
109	II	09	EE2211	01
110	JJ	10	FF1111	06

Consider a sample data,

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

For Eg,

If AA(Key) = 01(Value)  then AA1111(Test Key) should be equal to 01 (Test Value) considering the relation with AA = 01 and if GG = 07 then GG1111 should be equal to 07 (not 06) and if DD = 04 then DD1111 should be equal 04(not 02) without sorting the columns.

Please suggest some solutions

[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]

According to your solutions the rows and columns are interchanged but i want a solution in which no values are interchanged because all the fields are related to each other.

In short, the sample data remains as it its but an extra column is added for the matched result.

Comparing "test key" = "test value" in comprising with "key and value".

[atcodedog05 · Accepted solution]

Hi @vijaylnyadav 

Something like this?

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

[vijaylnyadav]

Thanks a lot.

This is what I am looking for.

[atcodedog05]

Happy to help 🙂 @vijaylnyadav 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂