I have a requirement where i need to select distinct column values from a column in excel and then i have to filter those values in another excel to get data of corresponding distinct values and i can use them in some ERP.
Example : excel1(dt1)
Column 1 A A B B B C C
I need A,b,c values from this column1 and then i need to filter on another datatable2 like this
Select column1 from dt2 where column1 in (A,B,C);
Can anyhelp me on that, how to do that in uipath ?