Compare two columns from two excel and update values to the first row from the duplicate rows

[s.panuganti]

Hello all,

I need to compare two columns A and B from two different excel files, if the values are matched get the value from column C in the second file of that particular matched row and update this value in the column C in the first file in the first row of duplicate rows with out removing duplicate rows.

[Akshay_More1 (Akshay More)]

hi @s.panuganti

Could you please refer below article for similar question already posted in UiPath Forum.

What is the Fastest Way to Match One Column With Another Column

Hi All Lets say I have an excel data that contains Column 1 | Column 2 A | A B | B C | C D | D E | F G | G H | I Column 1 and Column 2 supposed to match on each row ( A supposed to match with A, etc) so therefore this excel suppose to return that there are discrepancies on row E and H. What is the fastest way to detect if there is discrepancy on this excel? I prefer not to use for each row as I think that repeated loop on a lot of lines may result in a lot of processing time. Thanks…

Please watch some videos related to excel activites

How to Compare DataTable Column Headers in UiPath - Full Tutorial

UiPath Tutorial 30- Compare Excel Sheets or Data Tables and Remove/Delete Matching or Duplicate Rows

Match and Paste Data Across Sheets | Loop Datatables | UiPath | (Excel Automation UiPath) | RPA

Thanks,
AM

[ashwin.ashok ((TheCodingTheory))]

Hi @s.panuganti ,

Welcome to the UiPath forum.
It is a little hard to provide a proper solution without test data, but I’ll try my best.

(From row in dt1.AsEnumerable()
Let chk = dt2.AsEnumerable().Where(Function(w) 
w("A").ToString.Trim.Equals(row("A").ToString.Trim) And 
w("B").ToString.Trim.Equals(row("B").ToString.Trim).ToArray()
Let ra = new object(){row(0), row(1), If(chk.Count()>0,chk.First(), "")}
Select dt_result.Rows.Add(ra)).CopyToDataTable()

If you would be so kind as to include a test data, I can create a sequence for you.

Kind Regards,
Ashwin A.K

[s.panuganti]

No, none of them are supporting me. Please give few more suggestions.

[ppr (Peter)]

@s.panuganti

@s.panuganti

in the first file in the first row of duplicate rows with out removing duplicate rows.

maybe the definition of duplicates are to respecify (1, n, All Cols)

We do understand:

input:

result:

Flow:

for each typeargument: datarow

FirstRows:

(From d In dt1.AsEnumerable
Group d By k1=d(0).toString.Trim, k2=d(1).toString.Trim Into grp=Group
Select g=grp.First()).toList

item(2) =

(From d In dt2.AsEnumerable
Where d(0).toString.Trim.Equals(item(0).toString.Trim)
Where d(1).toString.Trim.Equals(item(1).toString.Trim)
Select c=d(2)).FirstOrDefault()

Find starter help here:
GetValueFromMatch_2Tabs1Col_UpdateLeftFirstDupOnly.xaml (12.8 KB)