Output Sheets by country + Master sheet

[Henrytabares]

Dear Community, 

After searching hours, I gonna need your support here...

I have below data set: 

#	Country
1	Argentina
2	Brazil
3	Bolivia

I need to output within the same workbook below structure: 

1- Sheet that contains the above table "as is".

2- One sheet per country. 

I know that If I set up the output this way (Change file/table name using the column [Country]) I will get one sheet by country....but I loss the single sheet that contains the table above...

Is there any way I can obtain both results same output file?

Any training material available I couldn`t find?

Thank you!

Henry

[binuacs]

@Henrytabares 

[RolandSchubert · Accepted solution]

Hi @Henrytabares ,

there is no additional option in terms of "output original sheet in addition", but you could create a duplicate of the original sheet.

I create a copy of the original sheet and an additional column with the sheet name for the "master table". In addition, I create this column for the "detail sheet" (i.e. the original data set), union original and copy and use  output tool, change table name by the new column and do not include it in output. 

Let me know if it works for you.

Best,

Roland

[Henrytabares]

@RolandSchubert your solution was not just efficient, smart...but also beautiful as a Goehte's poem! THANK YOU SO MUCH!!!!!!

@binuacs Thank you as well, your solution also made me think about the usage of "block until done".

This community is the best!!!!