Different Outputs - Multiple tabs - Same file

Question

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.

Sarath27 · Answer

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.

Analyst_12345 · Answer

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

geraldo · Answer

@Sarath27

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