Data Validation

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

Datasets

Accepted answers

atcodedog05

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

match key.yxmd

All comments

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 key.yxmd

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".

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703