Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

Rename Fields Depending on a Specific Value

Cfdiaz2103
8 - Asteroid

Hi guys!

 

Need any kind of support with this:

 

In Designer, I've got two fields that I would like to rename, depending on the corresponding value.

 

For example, the current names of these fields are "THEN" and "NOW". Next, we have a field that contains the value "2021" and another field that contains "2022" as well. As you can imagine, I need to replace the "THEN" word by "2021", and the same process for "NOW" by "2022".

 

I'd appreciate any help with this.

 

Thanks. 

6 REPLIES 6
aruiz-itp
11 - Bolide

HI @Cfdiaz2103 

 

Depending how you receive the data you can use 

- a dynamic rename column with one of the options

- a multi field formula

 

Maybe if you share how is the data coming we can help you better

gabrielvilella
13 - Pulsar

Please provide a sample dataset.

ArtApa
Alteryx
Alteryx

Hi @Cfdiaz2103 - Here is how I understood the problem:

ArtApa_0-1643428196540.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Cfdiaz2103 

 

Here is a solution assuming you have a separate mapping file.

 

atcodedog05_0-1643435312087.png

 

Hope this helps : )

 

Cfdiaz2103
8 - Asteroid

Hey @gabrielvilella !

 

Sure. Attached you can find the values and the desired output

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Cfdiaz2103 

Cheers and have a nice day!

Labels