Forum Discussion
Check for null in conditional column
Hi, I am trying to create a conditional column for a date/time field and need to check to see if the field is null. What should I enter in the Value field on the Add Conditional Column dialog bo...
I just ran across this myself, when creating a synthetic key from multiple fields, with the use of concatenation. Once completed, the synthetic key was used against a singular field in a conditional column, whereby if the synthetic was null then the alternative was chosen.
The new, conditional column would fail.
The root cause was that one of the fields used to crate a synthetic key was itself a null at times. Thus the key then failed. That then made the conditional column fail - a domino effect. I.e. in SQL this would not occur so it took me forever to figure this out.
Microsoft has a problem here for sure.
Mariusz