Forum Discussion
Conditional column if condition for blank text column
How should I create a new column with below condition:
If the column(Emp_Nm) is blank then NA_NAME =1 else 0.
Emp_id Emp_NmNA_NAME
| 101 | a | 0 |
| 102 | b | 0 |
| 103 | 1 | |
| null | 1 | |
| 104 | d | 0 |
What should be the value in conditional column for the new column?
1 Reply
if [Emp_id] = null then 1 else 0
So I guess your value should be null.
