Converting to string for replace formula

[Anasitani]

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.

[IraWatt]

Hey @Anasitani,

Can you attach the data for the workflow?

[binuacs]

@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]

Hi binuacs,

I tried but unfortunately to no avail.

Many thanks

Anas

[IraWatt · Accepted solution]

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