question

UnnatiSinghMINDTREELIMITED-7872 avatar image
0 Votes"
UnnatiSinghMINDTREELIMITED-7872 asked SaurabhSharma-msft commented

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.

azure-data-factory
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @unnatisinghmindtreelimited-7872,

Thanks for using Microsoft Q&A !!
In order to suggest you any alternatives we need few details from you like -
1. 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 ?
2. 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

0 Votes 0 ·

@unnatisinghmindtreelimited-7872 Following up as I haven't heard back from you.

0 Votes 0 ·

@unnatisinghmindtreelimited-7872 Please let me know if you need any help on this issue.

0 Votes 0 ·

0 Answers