How to Get Distinct Values from excel

Help StudioX
, , ,
1

Hi All,

I have a requirement where i need to select distinct column values from a column in excel i used Dt.DefaultView.ToTable(true,“Team”) this in assign activity but i also used lookup range because of that my code is considered the 10, 11 — as 1.

For Example Team1 — Team10, Team11 is in my excel but My code insert the Team10 and Team11 values in Team1. Can anyone help me to get distinct values.

@Pratik_Wavhal @hacky @divyaag

2

Hi @Bhupesh_Gupta

U want to select distinct values in excel from a column

So what condition u put there for that

May I know

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

3

@Bhupesh_Gupta
find some starter help here:
FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB)

1 Like
4

Attached my Workflow, in this for Team10 and Team21 it insert the values in Team1 and Team2New folder (4).7z (53.1 KB)

5

Please find attached workflow @NIVED_NAMBIAR

1 Like
6

Sir i looked through your workflow

do u want to transfer details from input file to output file

Can u give me overview of this process? @Bhupesh_Gupta

1 Like