App to populate different tabs in a single excel

[Tranda]

Hi all,

Just wondering if anyone know of a way to have an app populating data in different tabs within the same excel workbook?

Reading through several posts i've tried;

1. using parallel block until done
2. Parallel block until done connected to a Block until done
3. Parallel block until done connected to a wait a second
4. Chaining my Parallel block 
5. 
6. Using AMP engine

The error message i keep getting is the file is in use by a another process

[Qiu]

@Tranda We can use a formula tool to format the fullpath then output.

[Tranda]

Hi Qiu,

Thank you for your reply

I actually already have a similar process in my workflow that imports a template and creates a file where the data is stored however it seems that the workflow tries to do something to the other tabs before processing of another tab is completed

This doesn't happen all the time but enough to be annoying

[mceleavey]

Hi @Tranda ,

Yes, this is because it's trying to write multiple tabs to the same file and Excel can't support multiple writes to the same open file. 

To accomplish what you need, try doing what @Qiu suggested but wrap the output into a Batch Macro and use the grouped filepath, including the sheet name, as the Control parameter. 

Then simply overwrite the filepath that is being used each time. This will ensure the file is closed in each write instance.

Hope this helps,

M.

[Tranda]

Thank you both for your help 

Sorry but i'm fairly new to Alteryx, i wasn't able to open Qiu's file

Would you have an example i can use as reference ?

[Tranda]

Hi mceleavey,

I managed to open Qiu's workflow, issue was due to the version of Alteryx that i have

How do i wrap the output into a Batch Macro and use the group filepath as a control parameter?

would you have an example somewhere that i can use as reference?

Thank you in advance