Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Add Rows in between the existing data rows.

Highlighted
7 - Meteor

Hi Guys,

 

I am working on a data that has more that 10,000 rows, that requires me to add a blank row in between the data sets that I have. Can someone guide me on this.

 

 

Example:-

 

My input is.    

A100
B200
C300
D400
E500
F600
G700
H800

 

Output required

A100
  
B200
  
C300
  
D400
  
E500
  
F600
  
G700
  
H800
Highlighted
Alteryx Partner

Here is a simple way.

 

Put in a record ID field -  then create one stream with only the record ID.    Union it back to the original,  sort, then remove the record ID with the select.

 

You might need to watch the output order on the union to get the blanks before or after.

 

 

Vantage_james_0-1581499028609.png

 

 

Highlighted
Alteryx Partner

Hi RajayKumar,

 

My approach would be the following: I would use the generate rows tool.

 

DiegoParker_0-1581505537820.png

 

Please find the workbook attached.

 

Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego

 

Labels