Output data... Two outputs to one Excel tab and data is side- by- side

Good morning.. I am trying to build a workflow where two separate outputs are placed on the same spreadsheet but are beside each other and not in the same columns. Also, I need to include subtotals.

I've attached an example of what the report looks like in Excel and I've attached a copy of the workflow I currently have. I'm able to build out what I need the reports to include... but I'm having trouble include subtotals on the amounts and placing the reports side by side for viewing.

Thanks in advance;

Lisa

Alteryx Excel Example.xlsx

Alteryx Example.docx

Output

Tips and Tricks

Help

Documentation

Accepted answers

Hi @lisamccullough

To output side-by-side, config your output option to Overwrite Range and specify to write to:

Eg.

C:\temp\Date Entry Output.xlsx|||Sheet1$A2:I43

C:\temp\Date Entry Output.xlsx|||Sheet1$M2:U43

Hi @lisamccullough

Here goes..workflow attached. .calculated and laid out your June data...apply same for your July.

The canvas isnt too pretty...but works.

lisamccullough.yxmd

All comments

Hi @lisamccullough ,

Can you please provide some sample input data you are working with.

Best,

Jagdeesh

Sure. Please see the attached.

June Report.xlsx

July Report.xlsx

Hi @lisamccullough

To output side-by-side, config your output option to Overwrite Range and specify to write to:

Eg.

C:\temp\Date Entry Output.xlsx|||Sheet1$A2:I43

C:\temp\Date Entry Output.xlsx|||Sheet1$M2:U43

Thank you! This worked like a charm.

Any idea how I can add in subtotals and totals to the Double strings?

Hi @lisamccullough

Is subtotal and total already present in the data or does it need to calculated? If it needs to be calculated can you tell us how its calculated?

Awesome @HomesickSurfer 🙂👍

Quick Links

Tags

This months top contributors