Retaining Tab

Question

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?

binu_acs · Answer

@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,

Grail030510 · Answer

@binu_acs 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

binu_acs · Answer

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

Excel_output_091023.yxzp