Forum Discussion
replace null values with content from another column based on condition
hi everyone,
i have a problem with replacing null values with content from other column. The scenerio is something like this. let say i have three columns A,B,C
| A | B | C |
| X | 10 | 10 |
| X.1 | null | 10 |
| X.2 | null | 10 |
| Y | 11 | 11 |
| Y.1 | null | 11 |
| Y.2 | null | 11 |
C is my custom column created based on data from two columns A and B. please help with the query to construct above scenario.
Thanks,
Sivaaprataap.
On "Add Column" tab duplicate column B to C
On "Transform" tab select column C, then option "Fill" - "Fill Down".
Looks like Column A is not required to determine the values in column C.
2 Replies
On "Add Column" tab duplicate column B to C
On "Transform" tab select column C, then option "Fill" - "Fill Down".
Looks like Column A is not required to determine the values in column C.