How can we get distinct values from an array in ADF ?

Hi all ,

Suppose an array : [200;455;677;344;344;677] , I want this array to become distinct and give an output as : [200;455;677;344] .

Note : This array is a record of single row in a table.

This is to be done in data flow through expressions and functions .

Please give a solution for the above issue.

Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-04-02T23:21:36.983+00:00
Hi @Unnati Singh (MINDTREE LIMITED) ,

Thanks for using Microsoft Q&A !!
In order to suggest you any alternatives we need few details from you like -

How are you constructing this array from a single row. Is the logic is in your data flow or if you are sourcing it from any other location ? What's the data type of this column - is this a text column ?

I also see values are separated by a ; (semi-colon). Is this constructed this way or you construct it as a comma separated array ?

Thanks
Saurabh
Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-04-06T18:12:39.93+00:00

@Unnati Singh (MINDTREE LIMITED) Following up as I haven't heard back from you.
Saurabh Sharma 23,751 Reputation points Microsoft Employee

2021-04-08T23:32:16.99+00:00

@Unnati Singh (MINDTREE LIMITED) Please let me know if you need any help on this issue.