community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Arranging output on final Excel file

Bolide

I'm running a Workflow that is that identifies Stores and what group they are in.  Is there a way, after each group moves to Excel to add the Header Line again followed by a space and then the next group and repeat and repeat?  Thanks in advance for any ideas / help.

 

Example:

GROUPCHAINNABPSTORE_NAMEADDRESSCITYSTZIPPhone()
A110590554ABC Store100 Main St CA91604(818)506-1111
A153148461Some Random Store200 Someplace St NJ07114(862)276-2222
A174444725Store Name Something3163 S CHURCH ST TN37127(615)225-3333
         
GROUPCHAINNABPPHARMACY_NAMEADDRESSCITYSTZIPPhone()
B4120590554STUDIO PHARMACY5 South St CA91604(818)506-5555
B483148461709 ACE PHARMACY10 Another St NJ07114(862)276-2222
B464444725LIFEPOINT PHARMACY15 Maple St TN37127(615)225-1111
Magnetar
Magnetar

Hi!

Yes, with the Table and Render tools, it's easy.

In the table tool, you would set a grouping level at the top, and you'd choose "Group" in your example below. This creates separate tables, complete with headings, for each group level.

Then you'd add a Render tool. In that tool, configure the report to add whitespace between groups. Here's a snapshot of the render toolimage.png

Labels