Data Comparison

bsanthoshpk

Hi All,

I want to compare column vs column(with in same table) and report any data has been modified or not,

Requirement:

Example I have list of column separately

1)Take the column list one by one for eg Column1

2)look for that column in the table

3)now take 'Right_Column1'

4)compare data both, if same, no action required, if different, write' yes' in modification column

5)Now take the next column in 'list of columns', here we go with coloumn2

6)look for the column in table

7)now take 'Right_column2'

8)compare data of both, if same, no action required, if different, write' yes' in modification column

9)do this until list of columns are completed,

Column1	Column2	Column3	Column4	Right_Column1	Right_Column2	Right_Column3	Right_Column4	Column5	Column6	Modification
Apple	26	Northwest	c12	Apple	26	Northwest	c12	ee	ew	No
Orange	45	Southeast	d34	grape	45	Southeast	d34	we	ut	Yes

List of Coolum's

Column1

Column2

Column3

Column4

Developer

Best Practices

Preparation

Data Investigation

Accepted answers

Christina_H

There's no need to compare column by column, you can transpose the data and compare them all at once.

Compare columns.yxmd

All comments

ShankerV

Hi @bsanthoshpk

I believe you ask is very simple.

But reading a big passage is something which I get confused and seems complex.

Can you share the Input and the desired output will be easy to understand and work on the solution.

Many thanks

Shanker V

Christina_H

There's no need to compare column by column, you can transpose the data and compare them all at once.

Compare columns.yxmd

bsanthoshpk

Hi @Christina_H

Awesome, Thanks a lot

bsanthoshpk

Hi @ShankerV

Thanks for your reply. got solution

bsanthoshpk

Hi @Christina_H

Thanks for sharing your knowledge. But I need one more small help.
I modified your workflow to add another column as circled.
That column says which columns has different data.
But now I have a trouble.
I also want to replace data in such varying columns.
Eg: record id 2, column1=orange ; right_column1=grape.
Now I want to see output as orange in right_column1 also.
Bcoz my end agenda is to find
- affected column names

- also replace the affected columns with new data. Column1(new data), right_column1(old data). So want to replace grape with orange in this case. Same way for every affected column in every record.

Can you pls help me on the same.

ShankerV

Hi @bsanthoshpk

Please find the below expected solution.

As per your expectation, the Right columns are replaced with the values of the Left column if there is a difference.

Also the columns which are amended are captured.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Repalce_Compare columns.yxmd

bsanthoshpk

Hi @ShankerV

Thank you so much sharing your knowledge, great work..

Also, i tried this way, i got expected result..

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703