Alteryx designer Discussions

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

How to unhide blank rows

Highlighted
8 - Asteroid

Hello All,

 

So i have basically used table tool followed by a render tool for getting my output.

I have put blank rows in my data, if you see in the row id between 42 and 44. The problem is it is coming as thin rows. Can anyone help me in getting it as full rows(blank one). What settings i need to do?

nazuk_0-1589865781145.png

 

Highlighted
13 - Pulsar

Hi @nazuk,

 

have you tried replacing the null-Value with a "blank"? I think this could space out the row.

 

 

Best

Alex

Highlighted
8 - Asteroid

@grossal 

 

Hi tried, not working.

Highlighted
13 - Pulsar

Hi @nazuk,

 

it seems like Alteryx always shrinkens null-rows or blank rows. We can trick ourselves around it using a different whitespace character. I have made up a minimal example:

 

grossal_0-1589869454310.png

Input: 

grossal_1-1589869479924.png

Output Browse:

grossal_2-1589869489802.png

Output Excel:

grossal_3-1589869522922.png

 

I have used the "hair space" from this website: https://beautifuldingbats.com/whitespace/.

 

I have done the "replacement" in the Table-Tool itself like this:

 

2020-05-19 08-26-12.png

 

I am not sure if this behavior is intended or not, but the trick should do the job. Let me know if it works for you!

 

Workflow is attached.

 

 

Best

Alex

Labels