Consolidating 3 Output Data Commands to Separate Tabs in One Excel File

[kkaczynski]

Hello - I am trying to accomplish the below and am struggling to combined my 3 outputs to one excel file with each output having its own separate tab.

• Inputs are 2 reports which include commission data
• I added a summarize to get the total commission by broker
• Last step is to compare the 2 files by broker to look for variances
  • This would be 1 of the 3 tabs
• And the other 2 tabs I wanted to show which brokers kicked out of the variance analysis due to not being on the other report and vice-versa for the other tab

Please let me know if anyone is able to help on this and thank you in advance!

[CoG · Accepted solution]

If you are not on version 2023, and do not have access to Control Containers, then you will need to turn off AMP Engine and use the Block Until Done Tool:

[kkaczynski]

An easier way to put it is - I am looking to have the results of each of the "Join" tools outputs ("L", "J", and "R") in one excel file with the results on separate worksheets in the excel file.

[CoG]

@kkaczynski 

Did you try the sample I included above? It should do exactly what you're looking for.

[kkaczynski]

Thanks Andrew, I saw your reply after posting the second comment. I will give that a go now!

[kkaczynski]

Thank did the trick, thank you so much!

[stanleyfeng2024]

Hi @CoG  - do you know how many tabs can be created / or output with this Block Until Done tool? Is it only 3 tabs?  I am trying to create more than 3 but always give me an error saying can't open the output file. My prior step before output is all correct, it just can save the output saying can't open file when is more than 3 tabs. Thanks.