Focal Point
Handling of NULL values in data flow

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5921068331

May 26, 2005, 12:09 PM
<Vaibhav Nimavat>
Handling of NULL values in data flow
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.

Thanks,
Vaibhav
May 26, 2005, 03:32 PM
newtofocus
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.