In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How do I rename some of my data inputs?

klaraklara
6 - Meteoroid

How do I make my dataset such that all items called "Shoe and boxes" are labeled "Shoes and boxes" instead?   

In other words such that the first table becomes the second table?

 

I have tried several if formulas, but without luck. I am a real newbie, and appreciate your kind help! :)

 

ItemPrice
Trouser100
Shoes and boxes30
shoe and boxes10
Jeans100
Top90
Shoe and boxes30

 

ItemPrice
Trouser100
Shoes and boxes30
Shoes and boxes10
Jeans100
Top90
Shoes and boxes30
6 REPLIES 6
JohnJPS
15 - Aurora

Will the following formula work:

IIF([Item]=="shoe and boxes","Shoes and boxes",[Item])
Kenda
16 - Nebula
16 - Nebula

Hey @klaraklara


Are these the only combinations of shoes/shoe and boxes in your whole data set? If so, you can add a formula with the following expression:

iif([Item]="shoe and boxes" || [Item]="Shoe and boxes", "Shoes and boxes",[Item])

 

BenMoss
ACE Emeritus
ACE Emeritus

If you have many such cases I tend to favour a lookup table, which you can perform a join on to return the true value for each item.

 

Another option, which probably isn't a good place to start as a newbie is the 'fuzzy match' tool which has great capability to match objects that are similar in name.

 

Ben

Kenda
16 - Nebula
16 - Nebula

@klaraklara yet another option, very similar to what @BenMoss said, would be to use a Find Replace tool.

klaraklara
6 - Meteoroid

Thank you  so much! it was very helpful!

bmmunoz
5 - Atom

How would you type the formula in if there are multiple combinations? 

Labels
Top Solution Authors