i have 2 excel d1 and d2
Are you referring to comparing data between two sheets?
Use the below expression by mentioning the reference column to get the common data between the two data tables.
inputDT1.AsEnumerable().Where(Function(row) inputDT2.AsEnumerable().Select(function(r) r(“ColumnName”).ToString).Any(Function(x) x = row(“ColumnName”).ToString)).CopyToDataTable
compare d2 to d1 and get all comon data same as d1 has
How about this expression
Hi @manoj_verma1 ,
Check this below attached workflow and I have used above files which you shared,
Uipath_GetCommonData.xaml (7.4 KB)
Hope this might help you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.