Render to multiple excel files

[Raj_2]

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

RJ

[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 

[BrandonB]

This thread should give you an example of how to set it up: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Naming-Tabs-in-an-Excel-Doc-Using-Rend...

[Raj_2]

this looks like i need to have 40+ tables and then formula, do we have any other options.

[grazitti_sapna · Accepted solution]

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

[Raj_2]

 Any idea why am getting this error, it is giving me results, but all truncated records. For Jan as header it is showing only "J"

[grazitti_sapna]

@Raj_2 ,is it possible for you to share a sample workflow to check this issue?If you cannot share it then try to change the paper size in render tool.Please refer to the screenshot change paper size to custom and then define the size and check if the issue stil persists?

Thanks.

[Raj_2]

Thank you , it kind of sorted, but below is the new issue.

Designer x64 The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended. ¶

[grazitti_sapna]

@Raj_2 , can you possibly provide a screenshot of your workflow to figure out where this error occurs?