How to change a letter and text froman output file ?

[patrikfrid]

Hi,
Im new to alteryx, have just been on introduction and I have some questions regarding to change letters or a text from the input file.
I have danish ø, æ and å that I want to change to o, e and a instead. I also wonder how I can change an text from the input from InStock to yes and OutofStock to replaced.

Anyone that can help me ?

[MarqueeCrew]

There are many ways to do this.  Here's one idea using a FORMULA expression:

Replace([String],"ø",'o')

repeat as needed.

This will also work for InStock to yes ...

Cheers,

Mark

[patrikfrid]

getting error on that string formula

[MarqueeCrew]

[String] was just my placeholder for your actual variable name.

Cheers,

Mark

[patrikfrid]

I dont understand, what variable name ? do I need to create an variable to replace some text ?

[jdunkerley79 · Accepted solution]

I would suggest a simple approach would be to use a Find and Replace tool with a look up table for each set of replace

 

The first find and replace is configured to match part of the text, the second is configured to match the whole field.

I have attached a sample doing this for the example you provided

[patrikfrid]

thanks, it worked as I wanted, just one more thing :)

I have some blank categories and I dont want them at all, is there any way to get rid of the entire row so it dont showing f ex row 100 and 101 on the screenshot ?

[jdunkerley79 · Accepted solution]

I suggest using a Filter tool with a basic expression of Category Is Not Empty

[patrikfrid]

thanks, that worked fine, thanks alot :)