Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Retain all sheets from Excel Input File when Outputting based on new File Path

WestonProhaska
8 - Asteroid

Hi All, 

Just have a quick question on the possibility or how I would go about this as it's stumping me. Maybe I need to brush up on my macro skills. 

 

Background: I have a master excel file with two tabs, Sheet A and Sheet B. I want to output to new individual files based on each record in Sheet B while keeping Sheet A with each output file.

 

Sheet A is my template that pulls information from Tab B and formats it. Tab A's sole existence is to be a a nice looking reporting function and not be altered by Alteryx. A template per say. 

 

Sheet B is my data tab which will be altered via my workflow. It has 300 unique records that I want to output to individual files with the file names derived from certain fields in the sheet. This means the file path changes each time I write to the new file based on my fields. 

 

Problem: I can output these unique records to new individual files just fine, but it drops Sheet A. This is obviously because it is creating a new file all together and not retaining the Master File's structure or other sheets. Ideally I would create or configure something to keep Sheet A along with my new file pulling from Sheet B. The Sheet A's format and cell references would all need to be the same in the end as well. 

 

Thanks for your help and consideration

4 REPLIES 4
WestonProhaska
8 - Asteroid

I have solved using the blob inputs and old discussion posts I found. However, I feel that is way more complicated than it needs to be? Is there a simpler solution?

Morgan_Thomas
8 - Asteroid

You could try something like the attached. Here i've used the formula tool to generate a file path based on the unique records in Sheet B. Then I appended that to the Sheet A data and updated the sheet name in that data stream to be "Sheet A". Then both outputs are set up so they use that outlined file path as the place to create the file with both tabs. Kind of confusing but i think it could work.

 

Thanks!

WestonProhaska
8 - Asteroid

Hi @Morgan_Thomas Thanks for taking a crack, unless you make this a package or the paths relative it won't be able to work on my end!

 

 

Morgan_Thomas
8 - Asteroid

Hey there. I've attached a packaged version and made the file paths relative. See if this one will do what you need

 

Thanks!

Labels
Top Solution Authors