Also is it a typo that your IsNotNull doesn't carry the link information.
Code: Select all
IsNotNull(DSLink.ColumnA)
And
If (Cond1 and Cond2) then Sol1 else Sol2
Moderators: chulett, rschirm, roy
Code: Select all
IsNotNull(DSLink.ColumnA)
And
If (Cond1 and Cond2) then Sol1 else Sol2
An "AND" condition will always evaluate both sides, so this will drop records with null values of Read_Lnk.P_MKT. You need to change your command to either an OR statement checking for nulls first or add a handle_null to convert the null to a legal numeric for your comparison.snt_ds wrote:...IsNotNull(Read_Lnk.P_MKT) And Read_Lnk.P_MKT <> 0
...
This will throw an error if the column is NULL.. since DS will be evaluating "value = 0" even if it is Null().ArndW wrote:Sure you can use OR - "NULL() or value =0" is the inversion of the condition.
Code: Select all
NullToValue(input.column) <> 0
Code: Select all
IsNotNull(input.column) and NullToEmpty(input.column) <> 0
Code: Select all
Not(IsNull(input.column) or NullToEmpty(input.column))