I have made one flow with the source and target both are SQL Server database.It is requirement that if the target contains the row coming from the source is same then it should be rejected.It is done with the row containing some values,but it can't identify the null values in the target and source as the same and insert it twice and more. How can i compare the NULL values as same? So it will not insert many times.Looking forward to answers.
Try adding logic to omit the compare if both the source and target columns are NULL. This can be done using the IS MISSING in the calcualtor.
|Powered by Social Strata|