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 |
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: