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.
What i'm trying to Do.
if this condition is true or the value of the column (product) is null
then send email task.... Otherwise, move to the next task.
here is the query:
SELECT COUNT(product), product
GROUP BY product
HAVING COUNT(PRODUCT) > 1