How to compare cells in an excel and result out in other column

Help Studio
,
1

Hi,
I have two excels (old and new).
I need to compare the excel columns based and if does match then make a column with the result as true, else false.

image
image991×265 4.93 KB

I’m using Dt table.
Need inputs on a better approach.

2

Can you upload the excel file ?
from the top of my head , it seems like mission impossible but maybe try to :

  1. read excel
  2. enter data to 2 seperate arrays /lists
  3. compare word by word
    I would like to try it and give you a proper answer instead of this quick thought from my head
1 Like
3

HI @Vishwanth_Raya,

I have created a workflow and attached. Please check. ExcelComparison.zip (20.0 KB)

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.