Forum Discussion

FILIPKACZMAR's avatar
FILIPKACZMAR
Advocate I
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 FILIPKACZMAR 
    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 FILIPKACZMAR 
    you can try 

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

    Regards