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

Multiple tables in single email

danieljcroberts
7 - Meteor

Hi Alteryxees,

 

I have a workflow that looks like this:

 

Alteryx Report 1.PNG

It essentially creates two separate tables which are then emailed to me. The two tables look like this:

 

Alteryx Report 2.PNG

Alteryx Report 3.PNG

 

Currently these are sent as two separate emails. I would like to send them in a single email (one after another). Clearly the tables don't have common columns so I can't just join them together and put them in one big table (besides visually I would like them separated).

 

I assume this must be possible. Any tips would be greatly appreciated.

 

Dan

 

5 REPLIES 5
patrick_digan
17 - Castor
17 - Castor

@danieljcroberts You should be able to use the layout tool. That will accept both of your reporting snippets and combine them into 1.

danieljcroberts
7 - Meteor

Hi Patrick,

 

Thanks for the suggestion. This is clearly a 'user' issue. But I was expected that I can take the layout tool and then have several workflows enter the tool and then sort the layout. Do I have to join it into one large table (although the data is complete separate) and then fiddle in the layout tool, or am I missing something?

 

Thanks for your help,

 

Appreciate it.

 

Dan

patrick_digan
17 - Castor
17 - Castor

@danieljcroberts I've attached an example. You would indeed need to join your data (by record position) first before the layout tool. Alternatively, you could union your data and then use a summarize tool but you would have less control around formatting.

 

I was thinking of the visual layout tool, which is under the laboratory category (or you can just search). This tool would indeed allow you to connect all of your streams. It's not yet production ready (which is why it's in the laboratory category).

danieljcroberts
7 - Meteor

Thanks, super helpful, just what I needed.

Kristina_Toll
7 - Meteor

This example helped me as well. @patrick_digan 

Labels