"Except" function on DataFlow DerivedColumn

Mick Tan 0 Reputation points


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

User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,472 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 28,076 Reputation points 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

    User's image

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