I am trying to solve something I thought would be straightforward. I have an application I'm creating, and I want the output of that application to be a table rendered into an Excel file. I would like to choose where this file is saved to on each run. Below is a screenshot of the relevant section of the app. Incoming is just a basic table with a few columns.
The Render tool is configured:
And the Action tool:
When I run the workflow normally, everything works, and the file is rendered to the [Redacted].xlsx file.
When I run the workflow as an application, I get an error because the File Browse tool is inserting the sheet name into the text I'm replacing with the action tool.
How do I change the file name and path in the render tool without including the sheet name so the render tool will see the string as a valid file name?
I found an unresolved post from years ago with the same question: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Outputting-a-Render-file-through-file-... I wonder if @rajatjain1 ever got the answer they were looking for.
Solved! Go to Solution.
Hi @Jeremy, try updating the value with this formula. This way won't matter what the user inserted as sheet name.
REGEX_Replace([#1],'(.*)\|{3}.*','$1')
Thank you, @gabrielvilella, that worked perfectly.