How to unhide blank rows

[nazuk]

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?

[grossal]

Hi @nazuk,

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

Best

Alex

[nazuk]

@grossal 

Hi tried, not working.

[grossal · Accepted solution]

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:

Input: 

Output Browse:

Output Excel:

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:

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