How to find distinct column values from a column in excel


#1

Hi All,

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 ?

Thanks
Ankti


#2

dt2 = dt1.DefaultView.ToTable(true,“Column 1”)