Converting to string for replace formula

Hello,

I am having an issue with a formula on Alteryx. So I'm trying to replace an x with a "Yes" and a "No" with nothing. The problem is that for some reason Alteryx reads it as a Numeric field and thus doesn't accept the replace functions. Ive attached the file below.

AnasItani.yxmd

Input

Error Message

Common Use Cases

Accepted answers

IraWatt

Hey @Anasitani,

Think this is what you are looking for:

I changed it to update the field not output a copy. Also you used 'AND' that is only for logical expressions. To replace both you can use two tools or one tool using this formula:

Replace( Replace([_CurrentField_],"No",NULL()) ,"x","yes")

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

All comments

IraWatt

Hey @Anasitani,

Can you attach the data for the workflow?

binu_acs

@Anasitani @I think you are using two replace functions in the same tool which is causing the issue. Can you try with one Replace function and check the result ?

Anasitani

Hi IraWatt,

I remade it using the text input.

Many thanks

Anas

AnasItani.yxmd

Anasitani

Hi binuacs,

I tried but unfortunately to no avail.

Many thanks

Anas

IraWatt

Hey @Anasitani,

Think this is what you are looking for:

I changed it to update the field not output a copy. Also you used 'AND' that is only for logical expressions. To replace both you can use two tools or one tool using this formula:

Replace( Replace([_CurrentField_],"No",NULL()) ,"x","yes")

Any questions or issues please ask
HTH!
Ira

Workflow0506.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703