Excel uipath question of automation

1)Suppose there are two excel files ex:-Sample 1.xlsx and sample 2.xlsx both have id column and Number column , my question is we need to take common id from both sheet.

2)Second question is from common id we need to display number column whose number is greater than 1 with common id .

3)Display Common id whose no. greater than 1 as a result in different excel sheet.

1 Like

Hi

Hope the below steps would help you resolve this

  1. Search as workbook in activity panel and drag READ RANGE activity and mention the first sheet name and get the output as dt1
    Use another READ RANGE activity and mention second sheets name and get the output as dt2

  2. Now use assign activity like this

dt1 = dt1.DefaultView.ToTable(False,”Commonid”)

And use another assign activity like this

dt2 = dt2.DefaultView.ToTable(False,”Commonid”)

  1. Now use a merge datatable activity and mention source as dt1 and destination as dt2

  2. Then use a assign activity like this

dt2 = dt2.AsEnumerable().Where(Function(a) Convert.ToInt32(a.Field(of String)(“commonid”).ToString.Trim) > 1).CopyToDatatable()

Cheers @Ak_4

Can u send example through xaml file