Alteryx Designer

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

Multiple Inputs to Output to One Excel File Multiple Sheets

Highlighted
6 - Meteoroid

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

Highlighted
9 - Comet

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.

Highlighted
6 - Meteoroid

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

Highlighted
9 - Comet

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

Labels