Multiple Inputs to Output to One Excel File Multiple Sheets

[Tamzid]

Hi,

I have to use two inputs and create a output file where the output is on different sheets of the same file based on the location ID. I have attached the two inputs and what the output file needs to look like.`

Is there a way to do this Alteryx. I haven't been able to figure it out based on the different topics on the community board. Also is there a way to automate an email at the end of the workflow?

Please provide any resources if available. Thank you

[DavidxL]

All you need is a Join to match the two Inputs together, followed by Output to xlsx with option to "Take File/Table Name from Field" checked. See attached.

[Tamzid]

I am unable to open this in 2018.1. Anyway it can be re-uploaded in an older version?

[DavidxL · Accepted solution]

Try this. You'll have to replace the Input files when you open it.