Multiple Tabs Output using render tool

Question

I have to format multiple tab using the reporting tool can any one give me a example how to do it for for multiple input. At present it just perform the output for the 1st Input ...Now how can i link the other output tab in the same above wire  ?

AngelosPachis · Answer

Hi @ShreyaSharma ,

Please find attached an example on how to output multiple tabs in a single excel file with the render tool.

Let me know if that worked for you.

Regards,

Angelos

Help_Render to multiple tab in 1 excel file.yxmd

messi007 · Answer

@ShreyaSharma,

I suggest you to use a batch macro in order to read the each file after that you add you're workflow as a macro as well.

Could you share the workflow, with sample data in order to help.

1- Read files :

Below how to read dynamically several files:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

2- Batch Macro:

in order to do the same steps for each file:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/4881

Regards,