Yellowfin
Dummy Column with NULL Value
In Union/Union All
queries we need Dummy column with a NULL value.
1) NULL Value
2) Date as NULL value.
Use some backdated standard date for
all NULL date. Ex: 1900-01-01(YYYY-MM-DD). If you would like to show NULL value in display for ‘1900-01-01’ use CASE
WHEN..THEN END by using calculated field.
No comments:
Post a Comment