Dynamically rename the header by user input

[Sshasnk]

Hi I have 4 columns that I have dynamically renamed the header it based on user input.

Example:

Fund	Cost in CY (Currency)	Purchase in PY (Currency)	Cost	Cost in PY (Currency)
ABC	145	523	21	32
NKL	456	654	52	21
AMN	456	756	456	23

Rules:

1. Take text input from the user for example in text input (alteryx app) we give input as USD

2. Then we have to change the column name which has Currency in it and replace it with the currency

3. Below is the output example

Fund	Cost USD	Purchase USD	Cost	Cost USD
ABC	145	523	21	32
NKL	456	654	52	21
AMN	456	756	456	23

[Hsolmaz]

Hi,

I believe the app attached is what you are looking for. Please let me know if you have any question.

[binuacs]

@Sshasnk One way of doing this

[DataNath]

Hey @Sshasnk you could do something like this, whereby you look for the presence of '(Currency)' in your starting header and replace that with the user-provided currency. The only issue you'll have here is dealing with headers that end up with the same name - Alteryx doesn't allow duplicate field names and so in the example above you'd end up with [Cost USD2] in the far right column. Here's an example of the app: