"Except" function on DataFlow DerivedColumn

Question

"Except" function on DataFlow DerivedColumn

Mick Tan 0

Hi,

i am trying to populate a column with an array with the use of "Except" function (example below) but the debugger on ADF seem to be having an issue with the return type of "Except" being Any[]. would anyone be able to advice if a casting is necessary or any other rectifications can be done?

User's image

AnnuKumari-MSFT 28,076 Reputation points Microsoft Employee

2023-05-11T06:49:13.3066667+00:00

Hi M. T ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
AnnuKumari-MSFT 28,076 Reputation points Microsoft Employee

2023-05-15T04:32:46.2966667+00:00

Hi M. T ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .

AnnuKumari-MSFT 28,076 Reputation points Microsoft Employee

2023-05-11T06:49:13.3066667+00:00

Hi M. T ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
AnnuKumari-MSFT 28,076 Reputation points Microsoft Employee

2023-05-15T04:32:46.2966667+00:00

Hi M. T ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .

Answer 1

AnnuKumari-MSFT 28,076 Microsoft Employee

Hi M. T ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you are trying to make use of except function in dataflow which returns a difference set of one array from another. However, you are getting error since the array values are not getting formatter properly . Please let me know if that is not the case.

Kindly try one of the below expressions to get the result: except(["10","20"],["10"]) or except(array('10','20'),array('10'))

User's image

Hope it helps. Kindly accept the answer if it's helpful. Thankyou.

AnnuKumari-MSFT 28,076 Reputation points Microsoft Employee

2023-05-04T05:46:43.61+00:00

Hi M. T ,

Just checking to see if the above answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

"Except" function on DataFlow DerivedColumn

1 answer

Activity