Free Trial

Alteryx Designer Desktop Discussions

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

Output blank rows in a Report Table

Newt
8 - Asteroid

For formatting ease, I would like to output occasional blank rows using the Table tool in the Reporting tab.

Most of the columns are Double, and when I feed a row of Nulls into the Table tool, it seems to convert the Nulls to zeroes, which is not what I want.

In one discussion about blank rows, I found a workflow that creates Nulls and when fed through the Table tool, it does not produce zeroes. 

However, the Table tool scrunches the blank row to almost no height, thus ruining the attempt to create some air between lines.

I have attached that workflow, with it feeding into a Table tool, and you can see how the blank lines become almost zero height.

 

Surely there is a way to insert blank rows into a Table to improve readability...  Yes?

Thanks for any help!

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

If I want to separate the data, I would use "Group By" setting rather than blank row.

 

Table Tool

TableToolGroupBy.png

 

Output Image

TableToolOutput.png

 

If you still want to use blank row, you may want to add some dummy charactors (such as "---") to [Account] field.

Output

TableToolOutput2.png

 

Just an idea. Hope this helps.

Newt
8 - Asteroid

Thanks for the suggestion about grouping by account, but that's not my situation.

 

I need blanks to separate sections of the output from each other... to put visual air in between a section of summary and a section of detail, for example.

 

The workaround I found is to use a Text reporting tool to output a character (say a pipe | ) and then formatting it to make the color of the pipe white (or whatever the background color is).  White pipe on white background produces the blank line, and it doesn't get squished down in the Layout/Rendering step like an actually blank line does.

Labels
Top Solution Authors