Except Unique Assert Transformation in Dataflow

Vaibhav 105 Reputation points
2024-05-26T08:02:22.9033333+00:00

I am trying to use Asset transformation in dataflow to check the dups in source. I am not able to get the correct result when using parameters that will have single or multiple columns as primary keys (example shared below) when using below expression.

Expression : byNames(split($primary_key,','))
1.$primary_key = 'orderid'
2. $primary_key = 'orderid,lineid'
User's image

User's image

When I input single column and without split in expression then its work fine.
Expression: byName($primary_key)

User's image

Kindly suggest the correct way to write the expression when using multiple columns.

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