Output to multiple Excel with multiple sheets

[mahadevaswab]

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

[JosephSerpis]

Hi @mahadevaswab I mocked up a workflow that output the files into Multiple Excels. Let me know what you think?

[MichalM]

@mahadevaswab 

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 ])

[mahadevaswab]

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

[JosephSerpis · Accepted solution]

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.

[mahadevaswab]

@JosephSerpis can you please advise how to get the similar output using Render tool.

[mahadevaswab]

@MichalM Can you please advise how to get the similar output using Render tool.

[JosephSerpis]

Hi @mahadevaswab I wrote a blog that showcases how to do this.

[mahadevaswab]

Thanks @JosephSerpis , it works perfectly.