Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Can Table or Layout tool include the value that data is grouped by?

JFurda
8 - Asteroid

Hello all, 

 

I have a collection of data that I'm using the report tools (Table, Layout) to build an email body going out to particular teams in my organization. The team wants the list of users grouped by the email domain they belong to. I have parsed the domain out from the email address and have the table tool grouping by domain. That part is working great. 

 

What I'd love to do is put a separator between each of the groupings with the name of the domain that the data is grouped by. I have a plan for a complicated solution, but I'm wondering if there's an easier way to do it in the tool. 

Current output: 

Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022SanaTizer1234574LIDBDBCASana.Tizer@abc.biz
11/14/2022JancieJudith-Jones1234575LIDBACDJanice.Judith-Jones@abc.biz
11/14/2022MarilynFreemason1234577LIDMF10Marilyn.Freemason@abc.biz
Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022JoeAnyman1234569LIDABCDjoe.anyman@abc.com
Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022CarolineReed1234571LIDC123Caroline.Reed@abc.net
11/14/2022ThomasMarshall1234573LID3210Thomas.Marshall@abc.net
11/14/2022DanaDanason1234576LIDAAAADana.Danason@abc.net
11/14/2022HowardWise1234578LIDHW3KHoward.Wise@abc.net
Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022JohnSmith1234567JSMITHJohn.Smith@abc.org
11/14/2022JillJones1234568JJONESjill.jones@abc.org
11/14/2022FrankLinn1234570FLINN1frank.linn@abc.org
11/14/2022JeffJefferson1234572JJEFFSNJeff.Jefferson@abc.org
11/14/2022RobertoClemente1234579RCLEMERoberto.Clemente@abc.org

 

Preferred output: 

abc.biz     
Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022SanaTizer1234574LIDBDBCASana.Tizer@abc.biz
11/14/2022JancieJudith-Jones1234575LIDBACDJanice.Judith-Jones@abc.biz
11/14/2022MarilynFreemason1234577LIDMF10Marilyn.Freemason@abc.biz
abc.com     
Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022JoeAnyman1234569LIDABCDjoe.anyman@abc.com
abc.net     
Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022CarolineReed1234571LIDC123Caroline.Reed@abc.net
11/14/2022ThomasMarshall1234573LID3210Thomas.Marshall@abc.net
11/14/2022DanaDanason1234576LIDAAAADana.Danason@abc.net
11/14/2022HowardWise1234578LIDHW3KHoward.Wise@abc.net
abc.org     
Conversion DateFirst NameLast NameEmployee IDLIDEmail
11/14/2022JohnSmith1234567JSMITHJohn.Smith@abc.org
11/14/2022JillJones1234568JJONESjill.jones@abc.org
11/14/2022FrankLinn1234570FLINN1frank.linn@abc.org
11/14/2022JeffJefferson1234572JJEFFSNJeff.Jefferson@abc.org
11/14/2022RobertoClemente1234579RCLEMERoberto.Clemente@abc.org

 

Table tool settings: 

JFurda_0-1668101786511.png

 

3 REPLIES 3
gautiergodard
13 - Pulsar

Hey @JFurda 

Please see attached for one way to get to your desired output!

I left the domain column in the data stream in the event you need to group on that field for your final output. 

gautiergodard_0-1668104261405.png

 

Hi @JFurda 

 

Please see below and attached. You can use the Report Text tool to add the domain to every table.

christine_assaad_0-1668104616723.png

christine_assaad_1-1668104650197.png

Hope this helps. Cheers!

 

JFurda
8 - Asteroid

This is perfect and incredibly simple. Thank you!

Labels