Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Adding a Blank Row

grsomer
8 - Asteroid

Hi,

I am trying to add a blank row into my workflow. I just need to add one blank row to the top of my output so that it is formatted to feed into an Excel Macro. Is there any way to add a single blank row to a workflow?

Thank you!

3 REPLIES 3
Philip
12 - Quasar

One way is to create a text input with a dummy row indicating it is blank, then dropping that dummy column later.

 

Insert blank row at top.png

BenMoss
ACE Emeritus
ACE Emeritus

@Philip's solution is the one I would recommend, though I have a feeling you may want the blank row above the header line, in which case this post may be useful: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-output-data-at-specific-row-and...

 

Ben

RogerNorthup
6 - Meteoroid

Amazing how great this is...

 

I wanted to add rows to the bottom of my exported Excel spreadsheet. Searched "adding rows" clicked on this thread.

 

Downloaded, inserted, and modified the solution (switching order of tables to combine) and re-ran my app to a perfect result.

 

All within about 3 minutes!

Labels
Top Solution Authors