Hi everyone! I’m building a workflow (configured as a Batch Macro) that needs to save data into an Excel file, creating or updating multiple worksheets (one for each parameter).
This workflow also formats the Excel file with a multi-line header.
In my case, I want to replace the “Planilha1” part of the output path with a value received via a Control Parameter (for example, “Plan 02”). I set up the Action Tool to “Update Value with Formula,” using the Replace() function where “[#1]” is the parameter value. However, when I run the macro, Alteryx still creates the sheet named “Planilha1,” ignoring the parameter value I provided.
Has anyone experienced this or knows what might be missing so the macro actually replaces “Planilha1” with the Control Parameter’s text? I’m attaching my macro workflow here so you can see where I might have gone wrong. Thanks in advance for any help!
