adding a blank line to a table

[becki]

I need to add a few blank lines to my output file.  I searched on "append blank line" but didn't find it.  Can someone help?  thanks

becki kain

[nick_ceneviva]

The attached worklfow shows how you could do this!

Essentially, before your final output you can use the sample tool to get the number of blank rows you want.  Then use the multi field formula tool.  Select all of your fields and make sure you uncheck the option to create a new output.  With that option deselected, you will be updating your existing fields.  Your formula should just be NULL().  Then union this field back to the rest of your remaining output.  The union tool has an option that lets you order by the input so you can choose to put the blank row at the beginning or end.

[patrick_digan]

@becki I had a need for this as well a while back and created a macro to accomplish this. It has an option to add any number of blank rows at the beginning or end. You can also blank out all the columns, or keep some if you need (For example, you may want to keep a field or 2 but blank out the rest). I'm attaching a quick example.

It's basically the same logic as @nick_ceneviva but just wrapped up into a portable macro that suited my needs.

[becki]

with adding in blank lines, I also have to reorder the output from say:

1

2

3

4

to

1

4

2

3

I thought I could attach a record ID tool to my output and then sort it but it doesn't seem to allow for skipping around.  is there a way to do this, in 10.6. 9?

thanks

becki kain