Alteryx Designer Desktop Discussions

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

Add Blank Row after Transpose

Brook_G
7 - Meteor

Hi.  I am hoping someone can guide me on this scenario.  I have used the Transpose tool to change my data into rows instead of columns.  Now I am needing to insert a blank row after each 4th row.  I have tried using the Generate Rows tool connected right after the Transpose tool, but it does not seem to be working for me.  It does not generate any blank rows, and it also messes up the sort order.  I attached a sample file showing what I see after Transpose and it is correct.  The sample file also shows what I am needing to see but cannot figure out how to accomplish.  Any help appreciated.  Thanks.

3 REPLIES 3
Qiu
20 - Arcturus
20 - Arcturus

@Brook_G 
Hope this is what you need for.

1228-Brook_G.PNG

Brook_G
7 - Meteor

This solution worked perfectly.  Thanks for the help.

Qiu
20 - Arcturus
20 - Arcturus

@Brook_G 
Glad to help and appreciate the accept mark.

Labels