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.
Hope the below steps would help you resolve this
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
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”)
Now use a merge datatable activity and mention source as dt1 and destination as dt2
Then use a assign activity like this
dt2 = dt2.AsEnumerable().Where(Function(a) Convert.ToInt32(a.Field(of String)(“commonid”).ToString.Trim) > 1).CopyToDatatable()
Can u send example through xaml file