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
Regards,
Raja G
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
Regards,
Raja G
with same uncleared requirements Duplicate of
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:
checked with minimized data samples:
find starter help here:
Match_ColSet_SeqEqual_MatchResReport.xaml (12.4 KB)
find LINQ starter help here:
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
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.