How to find particular matching column values to one excel to another excel

Hi Team,

I have 2 excel , I want find particular column values(column C to H) to one excel to another excel.

please anyone help out from this.

i have attached image for yours ref
Excel1
Excel2

Regards,
Raja G

with same uncleared requirements Duplicate of
https://forum.uipath.com/t/how-to-update-status-based-on-row-values-in-excel/350944/9

@ppr

My requirement is matching column values to one to another excel , whatever present in particular columns like(column C to H) to find another excel column(C to H) once present the same columns value put status to excel1

Regards,
Raja G

@Raja.G
We can start it with a LINQ

Variables:

Flow:
grafik

checked with minimized data samples:
grafik

find starter help here:
Match_ColSet_SeqEqual_MatchResReport.xaml (12.4 KB)

find LINQ starter help here:

2 Likes

@ppr @Charbel1

Thank you so much guys i got output for this matched and not matched, i have another query in same task

Whatever matched column in status excel1 should also move to excel2 matched column status

please help me out from this.

i have attached image for yours ref

Excel2
Excel1

Regards,
Raja G

it looks like you want also calculate the match status for dt2.

just swap the datatables within the LINQ and run it a second time where dl is from dt2, and dr is from dt1. Ensure dt has also the status column on end

1 Like

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