Rename Fields Depending on a Specific Value

[Cfdiaz2103]

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. 

[randreag]

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]

Please provide a sample dataset.

[ArtApa · Accepted solution]

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

[atcodedog05 · Accepted solution]

Hi @Cfdiaz2103 

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

Hope this helps : )

[Cfdiaz2103]

Hey @gabrielvilella !

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

[atcodedog05]

Happy to help : ) @Cfdiaz2103 

Cheers and have a nice day!