In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start 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