Different Outputs - Multiple tabs - Same file

[Sarath27]

Hi All,

I have 4 outputs

1. Summary 1 - Basic Table

2.Summary - 2 - Basic Table

3. A data with 435 rows, 25 columns

4. B data with 70k rows, 40 columns.

I want each of the above output should be in different tabs of Single .xlsx file.

I have gone through two options 

1. Using Reporting tool - Render - for creating each sheet - I prefer this more. Can you guys please suggest the best way and also suggest me how to achieve this in alteryx?

2. Using Formula tool -  Block until done.

[geraldo]

@Sarath27 

could you send a sample data and what your desired output would look like

[Analyst_12345]

You can use both the options. 
1. Render: to use this option, once you have your full path and sheet names, use a layout tool - under group by click on both full path & sheet names, choose orientation: Vertical with section breaks, select table under data field, select sheet names under section name. After this use a render tool, complete the basic configs, select 'layout' under report data, and just remember to select 'insert section breaks between records' under separator

2. Other approach would be to use block until done. But i would suggest using render tool. For more clarity you can once upload the sample workflow

[Sarath27]

Hi Geraldo,

its very simple to explain this.

Output A 

Output B  

Above outputs should be written in a single in two different sheets as Output A and B. That's what I am trying to achieve.