Preserve formatting on multiple tab output

[Carlyn]

Hi There, I have successfully created a file that outputs multiple tabs based on a specific column. I am however struggling to preserve the formatting in the output file. The approach I normally use for 1 tab is not working for multiple tabs. 

I have attached a screenshot of the configuration I would normally use. Does anyone know if there is an alternative option that would work for multiple tabs?

[niklas_greilinger]

Hi @Carlyn,

have you tried using the change entire filepath option? Maybe the range is lost, when only changing the filename.

[Carlyn]

Hi - thanks for responding. That doesn't give me the data split into seperate tabs unfortunately.

[niklas_greilinger]

You could use a formula tool to create a new column for the fullpath. Including Filename, Sheet and Range.

[Carlyn]

can you help with what the formula would be to do this?

[niklas_greilinger]

I added a workflow with a formula tool for the fullpath. The [Sheetname] variable should be your different tabs then. Please let me know if this worked for you.

"C:\Users\camacle\Downloads\Master Rec prep3.xlsx|||"+[Sheetname]+"$A1:AK100000"

[Carlyn]

Hi - I am not sure I understand the solution. It looks like your output is an alteryx db rather than an excel file. I have attached a trial file, the first output is providing the seperate tabs that I am trying to create, but the formatting is not preserving when I update it and save the excel and then re-run. The second output is where I have tried to add in your solution, but its not providing an excel file, so not sure where I am going wrong?

[niklas_greilinger]

Hi I just chekced your workflow. Please just try to change the Output to an .xlsx File and use the following configuration. You of course have to change the range in the formula to your needs.

[Carlyn · Accepted solution]

Thanks for coming back to me.  It asks me to specify a sheet name. Not sure where to go with this one, or if I need to be using a different tool to get the formatting to preserve on each tab.

[niklas_greilinger · Accepted solution]

Yes your formula is still wrong because you do not specify a sheet name. 

This is what your formula needs to be:

"C:\Users\camacle\Downloads\Test - seperate tabs.xlsx|||"+[Month]+"1$A1:AK100000"