Split column based on logical values

[shubhamamilkant]

I have a column name Wiped, which has a True and False value (logical data type), I need to split them into 2 columns Wiped.True and Wipe.False.

and instead of false it will be blank in Wiped.True and viceversa.

Wiped      Wiped.True       Wiped.False

True          True  

False                                   False

True          True

Can someone help me to solve this.

Thanks in advance

[amitchandak · Accepted solution]

@shubhamamilkant , Try like.

Based on Data type one of the two should work

Wiped.True = if([Wiped] ="True", "True", blank())

or
Wiped.True = if([Wiped] =True(), True(), blank())

Wiped.False = if([Wiped] ="False", "False", blank())

or
Wiped.False = if([Wiped] =False(), False(), blank())