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:

1 Like
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!

1 Like
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.
2 Likes
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) ??

1 Like
8

You need to give like this.

image

In Filter Wizard:
image

image

1 Like
9

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

1 Like
10

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

1 Like
11

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

1 Like
12

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