Dynamically rename the header by user input

Question

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

Example:

FundCost in CY (Currency)Purchase in PY (Currency)CostCost in PY (Currency)ABC1455232132NKL4566545221AMN45675645623

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

FundCost USDPurchase USDCostCost USDABC1455232132NKL4566545221AMN45675645623

DataNath · Answer

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:

Replace currency in headers.yxwz

binu_acs · Answer

@Sshasnk One way of doing this

Currency_1215.yxwz

Hsolmaz · Answer

Hi,

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

Column Name Change App.yxwz