Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Render to multiple excel files

Highlighted
8 - Asteroid

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 idCountryAmount
1Canada122
2Germany344
23US455
4Italy555
5Argentina344

 

 

regards

RJ

Highlighted
Alteryx
Alteryx

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. 

 

example.png

Highlighted
8 - Asteroid

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

Highlighted
Alteryx
Alteryx
Highlighted
8 - Asteroid

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

Highlighted
Alteryx Partner

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

grazitti_sapna_0-1592288574246.png

 

Highlighted
8 - Asteroid

 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"

 

 

Highlighted
Alteryx Partner

@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.

grazitti_sapna_0-1592303371165.png

 

Highlighted
8 - Asteroid

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. ¶

Highlighted
Alteryx Partner

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

Labels