I have two excel sheets having same column names and i have to compare the columns in a way like print the similar columns side by side and print the result as True or False in a new column .
please find the sheets below.
sheet_1 is my first sheet
sheet_2 is my second sheet
Result is the expected sheet
Note : Here Joining is done based on Emp ID field.
please mention the workflow how to proceed in order to get the expected result as Result sheet
Solved! Go to Solution.
I've mocked up a workflow that answers your question.
Hope that helps, let me know if you have any questions on the workflow
Cheers,
Angelos
Hi @suneelkumarparvatala , I had a similar problem to deal with earlier in one my projects. I tried using the same way as @AngelosPachis but I had around 100+ columns in one sheet so it took forever to create a formula for specific column. Therefore, I came up with a dynamic solution irrespective of the fact no matter there are n number of columns. Please refer to the screenshot and workflow attached along with this post.
Kindly go through it and let me know in case you have any query and mark this post as solution if useful.
Thanks.
Thanks @AngelosPachis, your framed solution helps me.
Hi @grazitti_sapna, yes i have columns more than 30 and i have to write similar logic for most of them.
thanks for the solution .