Rename Values

[mrich93]

Hi all,

This may be simpler than I'm making it out to be. But I need to rename values that are outputted:

Current names:

UPC12	Description	SUM Weekly QTY Cases	UNFI DC
099482160227	365 Organic Microwave Popcorn Butter Flavor	20.22044405	Hudson Valley
099482160227	365 Organic Microwave Popcorn Butter Flavor	13.76349553	Ioway City
099482160227	365 Organic Microwave Popcorn Butter Flavor	15.8025319	Lancaster

Bolded needs to change to:

upc	Description	SUM Weekly QTY Cases	UNFI DC
099482160227	365 Organic Microwave Popcorn Butter Flavor	20.22044405	Hudson Valley	HVA
099482160227	365 Organic Microwave Popcorn Butter Flavor	13.76349553	Ioway City	IOW
099482160227	365 Organic Microwave Popcorn Butter Flavor	15.8025319	Lancaster	LAN

I've attached my current alteryx workflow.

[CharlieS]

Hi @mrich93 

Do you have a look up table that relates these names to their abbreviations? Like "Hudson Valley" = "HVA". If so, A Find Replace tool in the Join category would do the trick!

https://help.alteryx.com/current/FindReplace.htm 

Otherwise, you'd have to create unique abbreviations each time, which can get tricky and may be inconsistent with other sources. 

[fmvizcaino · Accepted solution]

Hi @mrich93 ,

Do you need to do that automatically? If yes, please let me know the rule to create it.

Best,

FErnando Vizcaino

[T_Willins]

Hi @mrich93,

What are you using for your source for the rename values?  That source should have UNFI DC long name and abbreviated code in it.  You can bring in that data source and use a Join tool joining on UNFI DC long name to bring in the abbreviated code.

[mrich93]

This worked how I needed it to! Was easier than I anticipated. Thank you!