Output to multiple Excel with multiple sheets

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

Sample data.xlsx

Output

Accepted answers

JosephSerpis

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.

Excel_Multipe_Files.yxzp

All comments

JosephSerpis

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

Excel_Multipe_Files.yxzp

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

gl-code.yxmd

mahadevaswab

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

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703