Consolidating separate outputs

Hi Community,

I have attached a snip of my workflow. I am trying to get the separate output pairs (detailed and summary) into one workbook in excel. I have tried the report tools but i am not sure how to use these and get errors .

Effectively i'll have four files with two sheets in each. your help is much appreciated!

Thanks!

Workflow

Output

Join

Accepted answers

mceleavey

@ManuelRodrigues ,

you have different report names, so they are always going to write out differently. Change the name, for example:

.\Achim Dunnwald Report.xls|||Detailed

This then writes out to the same report but to different tabs.

I would also recommend not using a 1997 version of Excel. If you really MUST use Excel, use the .xlsx version.

I hope this helps,

Achim Dunnwald Report.xls

All comments

mceleavey

Hi @ManuelRodrigues ,

Can you post some mock data and your workflow so we can help?

ManuelRodrigues

@mceleavey attached.

Thanks!

mceleavey

Hi @ManuelRodrigues ,

I assume the error you were getting is that the sheet was in use by another process?

This would have been due to the fact that you were trying to write to the same sheet multiple time simultaneously.

I've used the Block Until Done tool and made it sequential, which should allow you to run this.

NOTE: I've only built this for the first so you can simply repeat for the others.

I hope this helps,

PO Reports -Workflow_mceleavey.yxmd

ManuelRodrigues

@mceleavey how can i get those two output files you have above in one excel workbook? is it by using the table and render tools?

Thanks!

mceleavey

@ManuelRodrigues ,

you have different report names, so they are always going to write out differently. Change the name, for example:

.\Achim Dunnwald Report.xls|||Detailed

This then writes out to the same report but to different tabs.

I would also recommend not using a 1997 version of Excel. If you really MUST use Excel, use the .xlsx version.

I hope this helps,

Achim Dunnwald Report.xls

ManuelRodrigues

Thanks @mceleavey

mceleavey

no problem.gif

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703