Excel comparing values

Learn
1

Excel1 : image

Excel 2image

Hi guys,

i wanted to compare from excel1 column 'grp-reason 'to excel 2 ‘grp-reason’
if co2 in excel1 matches with excel2 column ‘grp-reason’ then i need to copy the corresponding reason.

2

@Vinutha_L
find starter help here:
DataTable_Join_1Col.xaml (10.3 KB)

Also have a look on the Join DataTable Activity

1 Like
3

i wanted to compare from excel1 column 'grp-reason 'to excel 2 ‘grp-reason’
if ‘CO-4’ in excel1 matches with excel2 ‘CO-4’ then i need to copy the corresponding reason.

i was able to do but it was very slow as it compares each value in excel2.
how can i do it in a better way. like the bot should be able to identify at once in the entire column instead of going each value and comparing

4

had you have looked to the example? It is prototyping for a democase but is very similar to your case.

5

yes i saw, sorry i dint understand…wat have u done in drresult

6

readin your first excel into dt2
readin your second excel into dt1
define in the statement

On d("dt1ColNameOrIndex").toString.trim Equals dl("dt2ColnameOrIndex").toString.trim

in the datatable dtResult you will get the matching dt2 rows or an empty datatable

7

@ppr thank you

8

you are welcome. let us know if it was working or your open questions