Hi,
in my analytic app, i have my render tool set to update the value in the output file. When I run the analytic app, i choose the output folder and enter a. xlsx output file name, but then I get the below error. I already have the option set for "choose a specific output file" in the render tool. I am not sure why it doesnt output. It works if I don't run as an app. Thanks.
When I set the File Name as text.xlsx|||Sheet1, Designer show error.
At running it as analytic app, if you set the file name "Output.xlsx|||Sheet1", Designer will output error.
You have to remove "|||Sheet1" from file path.
The Render is a little different than the Output Data tool in that you don't actually specify a sheet. It will automatically just create 1 sheet in your output with all of your data. Given that, your output path should not include the standard "|||SHEETNAME" at the end and should instead end with your file extension.
In your action tool, you can specify to update the folder path portion.
If you do want to specify a different sheet name than the default, you'll essentially build your output path in a Formula tool and then specify to group by in the render. Hope this helps!
