Hi,
How can I rename many columns not manually, as per below:
Thanks a lot.
Hey @Krakan, do you have the year in your data as well by any chance, or something else to distinguish between fields? Without something to differentiate, you won't be able to have multiple fields called the same i.e. 2 of each quarter and 2 fields named 'FY' as is the case in your example. Alteryx will automatically rename them like so:
Whereas, if you had the years (for example) involved, something like the following would work:
Find in attachement the way of doing this mapping using the dynamic rename.
You can have a sample of new headers you want and replace simply by position.
Let me know if this solution works or not.