How to attach a file and table to email in workflow

[ianw91]

Hi All,

I am still new to alteryx and have come across a problem.

I am creating a workflow that will pull data from a query, dynamically name it to today's date and then output as a .csv file into a folder.

I then have the same file added as an attachment of an email which I intent to schedule to run daily. 

In the same workflow, I also want to pull data from a separate query, input it into a table and then have the table in the body of the same email above. I am struggling to figure out how to add the second data source + table to the workflow. Has anyone any suggestions? The screenshot below will give you an idea of my workflow.

Thanks!

[DavidSkaife · Accepted solution]

Hi @ianw91 

You can use a Join Tool, but join by record position, not specific fields. This should then allow you to select the Table  'field' in the body of the email

[ianw91]

Thanks David, this worked!