Fixed multiple row and output in every excel tab

[Will_Cheng]

Hi Everyone, 

I am building an Alteryx workflow but i get stuck, looking for a solution or any possible workaround. 

The below is the dataset. 

Field_1	Field_2	Field_3	Field_4
Text1	Text1	Text1	Text1
Text2	Text2	Text2	Text2
Text3	Text3	Text3	Text3
Text4	Text4	Text4	Text4
AAA	111	222	333
AAA	222	111	333
BBB	444	555	666
BBB	666	444	555
CCC	777	888	999
CCC	888	777	999

I need to output the data in a different tab so i take Field_1 as file/table name. 

But it also create 4 tabs "Text1" Text2" Text3" Text4" and i want all text data will appear in every tab

My expected result would be following:

Tab name: AAA   

Field_1	Field_2	Field_3	Field_4
Text1	Text1	Text1	Text1
Text2	Text2	Text2	Text2
Text3	Text3	Text3	Text3
Text4	Text4	Text4	Text4
AAA	111	222	333
AAA	222	111	333

Tab name: BBB

Field_1	Field_2	Field_3	Field_4
Text1	Text1	Text1	Text1
Text2	Text2	Text2	Text2
Text3	Text3	Text3	Text3
Text4	Text4	Text4	Text4
BBB	444	555	666
BBB	666	444	555

Tab name: CCC

Field_1	Field_2	Field_3	Field_4
Text1	Text1	Text1	Text1
Text2	Text2	Text2	Text2
Text3	Text3	Text3	Text3
Text4	Text4	Text4	Text4
CCC	777	888	999
CCC	888	777	999

Is there any way i can do this?

Thanks

Will

[mbarone]

It all depends on your data.  For your "AAA", "BBB", "CCC" rows in the original table, will they always be labeled with something as identifiable as AAA/BBB/CCC ?  If so, then it's an easy task.  If not, we'd need a "rule" as to know how to split the original table.  Row number, or something like that perhaps?  In other words, how do you know where the AAA / BBB / CCC rows are?

[Will_Cheng]

Thanks for the quick reply, The AAA/BBB/CCC is not fixed and it can be more than 3 label. 

Without the "Text Data", i can say it would be a easy task by taking Field_1 

I am expecting the text data will attach to each tab output, the current setup will split all data plus AAA/BBB/CCC tab do have text data attached.

My expected result would be something like below:

Hope i explain it clear enough.

[binuacs]

@Will_Cheng 

[atcodedog05 · Accepted solution]

Hi @Will_Cheng 

Here my take on it.

Worklfow:

Hope this helps : )

[Will_Cheng]

Hi Atcodedog05,

This is great, i actually have a similar idea by using generate rows function based on how many A/B/C item from the data. The result looks as same as yours. Thanks

[atcodedog05]

Happy to help : ) @Will_Cheng 

Cheers and have a nice day!