I am working with a workflow where I need to change 2025 to 2026 & 2024 to 2025. See the attached screenshot. When I open find and replace pop up, it opens global one and I am not able to replace. Is there any way to do that?
Leave the fields as is and then use a dynamic range to change the names? Would that work?
@Ronit_Gupta I'm trying to understand what you want to do.
Are you trying to change the formulas themselves or do you want Alteryx change the data?
I am trying to change the column/field name as well as the formula itself.
I changed first one manually both name and content. Same I need to do with all formulas.
@Ronit_Gupta I would approach it in a different way as next year this will need to be change again.
You should use generic heading such as Year1 and Year2. Based on date you will be able to assign current year to let say Year1 and previous year to Year2. Give to the automation what it needs to do and then your Dynamic renaming.That is what I would do so in the future this will not need to be modified again.
Understood! As I already changed my half of workflow. Any quick fix for now and then later I can work to modify with generic year name.
So what you will need to do at the very beginning rename fields to Year1 and Year2, then the formulas will not need to be change. At the very end just rename it to the original heading. So you will need to do some changes now but it will save future rework.
@Ronit_Gupta I had one WF like yours and I learned it in the hard way 😂 and will never repeat that mistake again 😉
@OTrieger thanks!
