Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Inserting Blank Rows

BrandonS4
8 - Asteroid

I am trying to insert 10 blank rows after each change in state but am having trouble.  I need the blank rows to be inserted after each change in the state column of the attached data.  Any help is appreciated.

 

Thanks!

 

4 REPLIES 4
binuacs
21 - Polaris
BrandonS4
8 - Asteroid

Thank you @binuacs 

BrandonS4
8 - Asteroid

@binuacs I now need help with something else regarding this.  The solution you provided is great and works but I just realized for the last row that is blank, I need to insert the names of my column headers after the last blank row.  In the screenshot you have above, I need row 13 to say Customer in the first column and State in the second column.  Any suggestions on how to do this?

 

Thanks!

binuacs
21 - Polaris

@BrandonS4 Let me know the attached workflow works for you

 

binuacs_0-1671099326141.png

 

Labels
Top Solution Authors