Compare Excel file with another

Help
,
1

Hi!!!,

Today, i have 2 Excel files and i want to compare the col 1 of the Dt1 and the col 2 in the Dt2, search de duplicate columns and delete it from Dt1, how can i do that?

2

See this thread:

3

Thanks for the reply, is not like that.

Its like copy the data table but this time i want to delete it, this is from Copy:

(From p In FiltNewDt.Select()
Where( From q In FiltNewDt.Select()
Where q(“lo”).Equals(p(“lars”))
Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()

4

Hi,
You can refer this link: https://www.uipath.com/kb-articles/excel-automation-compare-rows-from-different-tables

Thanks!

5

Thanks @Sat, i’m gonna try, make it in 1 assign activity

6
  • Use for each row in Dt2.
  • Use Filter Datatable activity.
  • Give your filter condition.
  • In columns tab use remove option.
7

In the filter Option in column i will put the name of the column in DT2 and in the value, put the name of the column of DT3, should i call it like, (from r in DT3.select where r(“ColumnName”).toString) ??

8

You need to give like this.

image

In Filter Wizard:
image

image

9

It Works, But is not returning the filtered rows correctly, maybe is not tanking de other Datatable to campare it

10

In output column tab, you need to mention the columns which are needed as output.

11

It’s working Weird but i thinks is mi fault, but it works, Thank you very much Mr. Vivek