Multi-Field Formula Tool - Chang Output to V_WString - changes 'False' to 0

Hello,

I am using the Multi-Field Formula Tool to change all fields in my data to a string.

However when I do this i see that fields with TRUE/FALSE values convert to 1/0, how can i avoid this? I need to keep the text as is.

The columns could have different values each time it is ran (e.g. run 1 the first column contains numbers, the next time it is a date, then a text) so this needs to be dynamic.

For example:

Source data

Output from Multi-Field Formula Tool

Setup

Common Use Cases

Accepted answers

Luke_C

Hi @Nicholas_Sinclair - just need to handle the nulls then. Assuming the field is still being input as a bool then the below should work. Otherwise please provide a representative sample of your data to get the best help.

IF Isnull([_CurrentField_])

Then null()

Elseif [_CurrentField_]

Then 'True'

Else 'False'

Endif

All comments

Luke_C

Hi @Nicholas_Sinclair

Alteryx is considering C as a boolean - try using another multifield formula to update booleans first, then the rest of the fields.

Nicholas_Sinclair

Thank you for that suggestion it helps but has thrown another bug, in my actual data i have columns with mostly null values but some values of true or false.

This is now turning all the nulls in to False.

Any suggestions?

Luke_C

IF Isnull([_CurrentField_])

Then null()

Elseif [_CurrentField_]

Then 'True'

Else 'False'

Endif

Nicholas_Sinclair

Awesome, thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703