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_1Field_2Field_3Field_4Text1Text1Text1Text1Text2Text2Text2Text2Text3Text3Text3Text3Text4Text4Text4Text4AAA111222333AAA222111333BBB444555666BBB666444555CCC777888999CCC888777999 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_1Field_2Field_3Field_4Text1Text1Text1Text1Text2Text2Text2Text2Text3Text3Text3Text3Text4Text4Text4Text4AAA111222333AAA222111333 Tab name: BBB Field_1Field_2Field_3Field_4Text1Text1Text1Text1Text2Text2Text2Text2Text3Text3Text3Text3Text4Text4Text4Text4BBB444555666BBB666444555 Tab name: CCC Field_1Field_2Field_3Field_4Text1Text1Text1Text1Text2Text2Text2Text2Text3Text3Text3Text3Text4Text4Text4Text4CCC777888999CCC888777999 Is there any way i can do this? Thanks Will Data.xlsx

Fixed multiple row and output in every excel tab

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

Data.xlsx

Output

Accepted answers

atcodedog05

Hi @Will_Cheng

Here my take on it.

Worklfow:

Hope this helps : )

fixed rows.yxmd

Output.xlsx

All comments

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?