Except Unique Assert Transformation in Dataflow
Vaibhav
105
Reputation points
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'
When I input single column and without split in expression then its work fine.
Expression: byName($primary_key)
Kindly suggest the correct way to write the expression when using multiple columns.