Retaining Tab

[Grail030510]

Hello, 

Can someone help me in the solution for this problem, I have an excel file which contains two tabs(Ex. Tab1 and Tab 2 respectively), the data that will be put on Tab 2 will be coming from another excel file

1.) Tab 1 is my summary / Pivot table Tab

2.) While Tab 2 is my Detail Tab(which will be coming from another excel File)

3.) The File name of the said file for Tab1 and Tab2 will have a date at the end of the file(Already done it)

Problem: After data wrangling using Alteryx,  all the data will be stored in Tab 2, so that Tab 1 can use the details for the Pivot Table, But the issue is After the output file has been written, The Tab 1 ( Pivot Table) is gone, How can I retain my Tab 1 when I use the Output File?

[binuacs]

@Grail030510 In the output file keep the PIVOT in the first tab and only write the Tab2. Attaching a sample workflow for your referene

[Grail030510]

@binuacs Thanks for the reply, But I forgot to tell that the source file is different from the output file, let me rephrase my scenario. Sorry for the misleading instruction. But Again Thank you

[binuacs]

@Grail030510 Keep the pivot in the output file in one tab (may be the same copy of PIVOT from the source file), and write the data in the other tab,