How to attach a file and table to email in workflow

Question

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 Answer

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