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! Workflow Screenshot.PNG

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

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!

Workflow Screenshot.PNG

Workflow

Output

Accepted answers

CoG

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:

Sample Workflow.yxmd

All comments

CoG

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:

Sample Workflow.yxmd

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!

Alpha325

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703