I'm trying to do to conditions:
One, if the incoming table, has duplicate rows or if the value is null in a column, then i want the condition to send an email, if not, then continue with the data transformation.
1. Can i use a query in conditional Split ? ,
2. i know one case can be null, but i can't figure out how to express that in the correct syntax.