Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 n...
  • MarcelBeug's avatar
    9 years ago

    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.