Forum Discussion

yc-bsa's avatar
yc-bsa
Regular Visitor
4 years ago

Help please - if null replace with data from another column

Hi All,  I am trying to adding a new column basically combining the data from the first two columns (marked A & B in the image).  If column A has a A, new column = A.  Or if column A is null, new ...
Need Help
yc-bsa's avatar
yc-bsa
Regular Visitor
4 years ago

Hi Gabriel, 

Thanks for your reply. I did try using null.type but same result (only pick up from column A)

 

 

Gabriel_Walkman's avatar
Gabriel_Walkman
Continued Contributor
4 years ago

Try "N/A" instead of Null.Type. Or replace the N/A values to null and then check for null (not Null.Type).

  • yc-bsa's avatar
    yc-bsa
    Regular Visitor
    4 years ago

    Hi Gabirl, 

    Thanks for your help, but both null and 'N/A' are part of the data so I cannot replace them. 

    Somehow I cannot attach the file so I have attached a photo of the sample data, hopefully that helps to explain better what I am trying to ask: 

    - if column 'ID category' has a value, column 'Category' should equal to this value no matter what (even if it's 'N/A');

    -only if column 'ID category' is null, column 'Category' should equal to 'Type Category'

     

    but as you can, my formula is only picking up value from 'ID category', even if it is null, it won't picking up fom 'type category'