This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Gather all 9 clues to complete the final Weekly Challenge on Dec 16!
I have above dataset after doing a pivot in Alteryx.I need to dynamically rename the column headers.
For eg:- We are in Q4 2017 currently hence I need 20174 COGS to be renamed as CQ COGS and 20173COGS as CQ-1 COGS.
Likewise When I reach 2018 Jan ,we will have a new column 20181 COGS and at that point of time it needs to be renamed as CQ COGS and 20174 COGS as CQ-1 COGS.How can we achieve the same in alteryx?.
The attached workflow should work. You would just need to replace the text input with your current workflow. Let me know if you have any questions!