Free Trial

Alteryx Designer Desktop Discussions

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

Insert blank rows

alexlyle
8 - Asteroid

I know there are alot of discussions along these lines but I can't find one that fits my predicament. I have roughly 68K rows. I need to insert blank rows such that every 7th row is a blank row containing 118 blank spaces. so it would be:

Row1

Row2

Row3

Row4

Row5

Row6

Blank row of 118 spaces

Row8

Row9

Row10

Row11

Row12

Row 13

Blank row of 118 spaces

Row15

...

10 REPLIES 10
LeroyMagee
6 - Meteoroid

I also would like to understand this as well.  Specifically, trying find out how to either add blank lines to the Output or just beforehand.  Thank you.

Labels
Top Solution Authors