Output multiple excel files using a single Excel Template with 2 tabs

[Xyleene]

Hello!! First I shall start out saying a bit of an Alteryx newbie. I've been searching the community threads to solve this but am going mad!! I'm hoping to get some help building a workflow that takes two inputs with a common "Region" field and exports individual Region files using a single excel template with two tabs. 

Please see the attached data samples

1. Input 1 - Active Products

2. Input 2 - Discontinued Products

3. Sample Template

Desired output goal would be: 

NAM file - with Active/Discontinued on separate tabs using excel template format

LAM File - with Active/Discontinued on separate tabs using excel template format

EMEA File - with Active/Discontinued on separate tabs using excel template format

APJ File - with Active/Discontinued on separate tabs using excel template format

Any help you can provide would be GREATLY appreciated!!!!

[apathetichell]

containers were just for my testing - you can ignore them... Can you confirm that you updated the path in the text input tool for the template? If - so can you share the file results on run? basically it should be creating the templates first - and if it doesn't it can't find a path.

[Xyleene]

I did update the path and it is creating the templates first! 😀

[apathetichell]

can you share the file part of your results window - something is off in the location of the files or the naming convention of the files created.

and make sure AMP is off for now.

[Xyleene]

Imported workflow – came in with 2 errors. Blob output and input were blank. I updated these with the folder location.

Output – just named test

Input – Pointed to template file

Updated template path - ran workflow with AMP off. The result is the expected 20 blank templates. 

PS - don't mind all of those "warning". The input data has Date/Number fields that show blank fields with a dash. I'm converting these to a Date/Number field since Alteryx can't have text/num value in the same column

[apathetichell]

This is weird. Did you deactivate containers with the output tools? Can you show me the results of the either join tool which bring the dynamic filename to match with the input file via price list name & sales channel? Assuming no changes happen to those fields in between the summarize tool and the join - those should match 1-1.

[Xyleene]

For the workflow the only things I changed were the Template Name/Directory and filled in the blanks for the Blob Input/output during import. When I open the workflow the output containers are turned off (I didn't touch those). 

[apathetichell]

toggle on the containers!

[Xyleene]

It creates blank templates but  I get the follow error message when you toggle the containers on (tried with AMP on and off):

[apathetichell]

can you share the file results screen?

[Xyleene]

Let me know if this is what you want to see: