Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Fixed multiple row and output in every excel tab

Will_Cheng
6 - Meteoroid

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_4
Text1Text1Text1Text1
Text2Text2Text2Text2
Text3Text3Text3Text3
Text4Text4Text4Text4
AAA111222333
AAA222111333
BBB444555666
BBB666444555
CCC777888999
CCC888777999

 

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_4
Text1Text1Text1Text1
Text2Text2Text2Text2
Text3Text3Text3Text3
Text4Text4Text4Text4
AAA111222333
AAA222111333

 

Tab name: BBB

Field_1Field_2Field_3Field_4
Text1Text1Text1Text1
Text2Text2Text2Text2
Text3Text3Text3Text3
Text4Text4Text4Text4
BBB444555666
BBB666444555

 

Tab name: CCC

Field_1Field_2Field_3Field_4
Text1Text1Text1Text1
Text2Text2Text2Text2
Text3Text3Text3Text3
Text4Text4Text4Text4
CCC777888999
CCC888777999

 

Is there any way i can do this?

 

Thanks

Will

6 REPLIES 6
mbarone
16 - Nebula
16 - Nebula

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
6 - Meteoroid

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 

 

Will_Cheng_0-1644008647958.png

 

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.

Will_Cheng_2-1644008946542.png

Will_Cheng_3-1644009042399.png

 

 

Will_Cheng_1-1644008925288.png

 

My expected result would be something like below:

 

Will_Cheng_4-1644009110922.png

 

Will_Cheng_5-1644009123957.png

Will_Cheng_6-1644009137383.png

 

Hope i explain it clear enough.

binuacs
20 - Arcturus
atcodedog05
22 - Nova
22 - Nova

Hi @Will_Cheng 

 

Here my take on it.

 

Worklfow:

atcodedog05_0-1644043408150.png

 

Hope this helps : )

 

Will_Cheng
6 - Meteoroid

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
22 - Nova
22 - Nova

Happy to help : ) @Will_Cheng 

Cheers and have a nice day!

Labels