Getiing all the Outputs in 1 Excel Sheet

Hey Designers,

I know how to export output in Excel but I need help in getting all the outputs in just one excel sheet. The attached workflow has 6 summarize functions and those are the outputs I need to export in 1 sheet.

I have exported the tables manually. The example is for reference to how I want the outputs to be.

Any help would be appreciated. Thanks in advance.

CHIPOTLE 1 CONCEPT.yxmd

Raw data (BU) - New Column.xlsx

Workflow

Reporting

Settings

Output

Transformation

Help

Dynamic Processing

Preparation

Documentation

Accepted answers

RobertOdera

Hi, @iamviraj13

Here you go!

Please mark as a solution + like.

Please click on the tools to see the custom configurations.

You can also do more custom work to rows, borders, etc., in the Basic Tables.

Custom rules to columns and rows can also be applied.

I only took enough of your data to create a 'shell' for you (to show you how to accomplish your end desire)

You will have to do the actual data prep (if any) that would come before the summation tool 🙂

Workflow

Excel Output

The workflow is attached.

Cheers!

For_iamviraj13.yxzp

All comments

RobertOdera

Hi, @iamviraj13

Please mark as a Solution if this meets your needs.

It would be very helpful if you exported a packaged workbook (so that we can read your input file because it's currently pathed to your file location).

Still, meantime, consider leveraging the Visual Layout Tool + Reporting Render Tool per below.

Click on Manage Layout in the Visual Layout Tool to arrange the tables.

You can configure the Render Tool as per below.

Good Luck!

iamviraj13

This step is not working for me as a solution. I have attached an input file in my original post.

iamviraj13

Hi @RobertOdera ,

The solution you provided me did not work. is there any other way of doing it? Thanks.

rupali_bhise

Hey @iamviraj13 ,

You just need to use 6 output to represent your output and add filename with specific cell., for 1st table example you need to add "filename|||Sheetname$A2:C7".

Hopefully it will help you.

iamviraj13

@rupali_bhise Thanks for the idea, but how can I get all at once? Like I just click on run and I have all 6 in one tab at once.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703