Render to multiple excel files

Dear all,

i have a country based reporting required and the input is below , require the country based output files in different excel sheets, i cannot create multiple table based on country, do i need to create a batch macro

Emp id	Country	Amount
1	Canada	122
2	Germany	344
23	US	455
4	Italy	555
5	Argentina	344

regards

Reporting

Accepted answers

grazitti_sapna

Hi @Raj_2 , if you just want to render the data and output into required format by grouping on the basis of country then try this workflow will create separate excel for each country. I hope it helps

Render-Group.yxzp

All comments

BrandonB

In your output data tool, the option down at the bottom will help you in doing this. First, set it up to write it to the Excel file of choice. Then, check the box down at the bottom to Take File/Table Name From Field. Select the column that you would like to use for your Excel tabs. Finally, you need to decide whether or not you want this column in your final output, checking the box if so, or unchecking if not.

Raj_2

Thanks Brandon, but am looking for Render tool not output tool since I have formatting requirements

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335