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

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
randreag
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
14 - Magnetar

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