Dear Team,
I have the attached data I want the output to multiple Excel based on the entity code with multiple sheets( Sheet Name should be GL Code)
File Name should be Entity code
Sheet name should be GL Code
Each Excel should have the Both GL code in different sheets
Thanks and regards
Mahadevaswamy
Solved! Go to Solution.
Hi @mahadevaswab I mocked up a workflow that output the files into Multiple Excels. Let me know what you think?
You can use the Formula tool to build out the file path dynamically and then use this path in the Output tool configuration. Example attached.
"C:\tmp\"+tostring([Entity Code])+".xlsx|||"+tostring([GL code ])
Hi @JS420
Thanks for the quick revert, and I would like to know is this possible to avoid File & URL coloum in Output files
Regards
Mahadevaswamy
Hi @mahadevaswab I amended the workflow to exclude those fields. But it's worth mentioning in the output tool you have the option to include the field in output you use to change the filepath.
@MichalM Can you please advise how to get the similar output using Render tool.
Hi @mahadevaswab I wrote a blog that showcases how to do this.
Thanks @JosephSerpis , it works perfectly.