Get distinct value in column excel

[AshwinS2 (Ashwin S)]

hi @saraawq
For distinct column values you can use the below query
Datatable dt=dt.DefaultView.ToTable(true, “DEPARTMENT”) in assign activity

Thanks
Ashwin S