Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

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

lisamccullough
8 - Asteroid

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

9 REPLIES 9
JagdeeshN
12 - Quasar
12 - Quasar

Hi @lisamccullough ,

 

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

 

Best,

Jagdeesh

lisamccullough
8 - Asteroid

Sure. Please see the attached.

HomesickSurfer
12 - Quasar

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

lisamccullough
8 - Asteroid

Thank you! This worked like a charm. 

 

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

atcodedog05
22 - Nova
22 - Nova

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?

HomesickSurfer
12 - Quasar

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.PNG

atcodedog05
22 - Nova
22 - Nova

Awesome @HomesickSurfer 🙂👍

lisamccullough
8 - Asteroid

Thank you so much! It works!... You're kindof a superstar.. Alteryx style...

HomesickSurfer
12 - Quasar

@lisamccullough  Thx! 🙂

I'm pleased it works for you!

Labels