Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to change a letter and text froman output file ?

patrikfrid
8 - Asteroid

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 ?

001.png

8 REPLIES 8
MarqueeCrew
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
patrikfrid
8 - Asteroid

getting error on that string formula

2018-11-07_22-40-56.png

MarqueeCrew
20 - Arcturus
20 - Arcturus

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

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
patrikfrid
8 - Asteroid

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

jdunkerley79
ACE Emeritus
ACE Emeritus

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

 2018-11-07_22-14-40.png

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
8 - Asteroid

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 ?

 

2018-11-07_23-41-33.png

jdunkerley79
ACE Emeritus
ACE Emeritus

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

2018-11-07_23-01-38.png

patrikfrid
8 - Asteroid

thanks, that worked fine, thanks alot :)

Labels