Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Changing True/False to 1/0

Hi,

 

my name is Filip and I want to change True/False to 1/0 in new column. 

 

But I cant find on the internet code which will work... 😞 

 

Can you help me? 

 

Thank you for help, have a nice day

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 
    you can try 

    new_column =
IF(column_name = TRUE(),1,IF(column_name = FALSE(),0))

    Regards

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 
    you can try 

    new_column =
IF(column_name = TRUE(),1,IF(column_name = FALSE(),0))

    Regards

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you 🙂

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        You're welcome 😀