In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Insert Blank Row When Data Changes

Cassie_Shaw
7 - Meteor

Hi All,

 

I have spent the whole morning trying to figure out how to insert a blank row when my data changes in specific column. For example:

 

Bob

Bob

Bob

Dawn

Dawn

Eric

 

I would like a blank row after the 3rd Bob, 2nd Dawn and 1 Eric. I have attempted to set up an "ID" (either 0 or 1) to use down the workflow with a Generate Row tool however I am not getting the desired output.


All help is appreciated :)

3 REPLIES 3
binuacs
21 - Polaris

@Cassie_Shaw One way of doing this

binuacs_0-1685041061117.png

 

RSreeSurya
9 - Comet

Hi,

 

Attaching the workflow, have a look.

 

Please note that in the concatenate end I have given ', '. 

 

RNSupraja_0-1685041019510.png

 

 

 

Cassie_Shaw
7 - Meteor

@binuacs @RSreeSurya Thank you both for your quick help. The issue was with my multi row formula. :)

Labels
Top Solution Authors