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]

o.k. - can you attach a browse screen before the output tool and see if the filename matches the files being created in the blob output?

[apathetichell]

I feel stupid. this needs to be in Template Path - probably fixed it in one version and sent over another... [Template Path]+"|`ALL EOS COMBINED`$A2:AZ500000"

That has to be the value sent to the full path qualifier - and right now the formula tool before both of the output tools are broken. They don't include the template file from the blob output - just the sheet reference.

[apathetichell]

there were a few issues on this so I'm sending over a new workflow.

[Xyleene]

Results in folder with AMP off & output containers on or off - Names don't match/no excel files created

Results with AMP on & output containers off - Files create but blank. Same result with AMP on & output containers on. 

Hahaha this workflow is sooo strange!

[apathetichell]

made a few changes and included some notes to help you troubleshoot the process.

[Xyleene]

Sadly I still can't get this to work 😭

1. Downloaded your file - changed files

2. Updated Template Copier Path

3. Should this formula say Active instead of EOS?

4. Should this formula say: [Template Path]+"|`ALL EOS COMBINED`$A2:AZ500000"

5. Error message when I run (AMP off): Error: Output Data (61): Unable to open file for write: - Can't open file:  The system cannot find the path specified. (3)

6. Sigh.. 

1. 2. 3. .

4. 5. 

[Xyleene · Accepted solution]

OMG - I just fixed it!!!!!!! Updated the formulas and added a Block till done!!!!! Thank you thank you thank you a billion times for sticking with me on this crazy workflow. Happy Friday!!!!!!!

[apathetichell]

Glad to hear. Sometimes we do need to use extra block until dones... Watch out running this workflow with very very small inputs - I wouldn't be surprised if the timing got thrown.

[Xyleene]

That's what I was thinking too but trust me I'm running it now with real data (2 million records) so that def. won't be an issue. YOU ARE AMAZING and again thank you soooo much for your help. 😘