Reporting - Table Not aligned when Starts with Null

You can join your data first and then create the table to get the list you are after. Otherwise, replace your Nulls with something and then generate so that the Null rows are not removed.

suby

I don't want to Replace NULLS with something else.

For Row 1 & Row 4 I wanted the Column X & Y always to be blank becoz that's the layout I'm trying to achieve.

Thanks

CoG

The issue you are experiencing is not that the rows are being removed but that Alteryx renders the tables with text wrapping. Null and several of its counterparts (e.g. empty string "", breakable space " ", etc.) have no associated height, causing the row to collapse (not disappear).

To resolve the issue you are having, you can use the Render Tool and output to excel where cells have fixed height, or replace nulls with non-collapsing character like no-break space U+00A0, or CharFromInt(160) in Alteryx:

IIF(IsNull([X]),CharFromInt(160),[X])

Repeat for [Y].

Multi Field Formula Tool could also be used if more fields are involved.

I have a similar discomfort as @KGT , There are likely better ways to accomplish what you are trying to do to achieve a certain output format than break up a perfectly good table and re-glue it together. If you can share more details about your actual use-case, more assistance can be provided. But hopefully you better understand the issue you are having.

Hope this helps and Happy Solving.

binu_acs

@suby

Sample WF- Allignment.yxmd

suby

Hi Binuacs,

Thanks but I wanted in the output in this format that's the reason I split in the data in two streams using the select tool.

can we achieve this result.

suby

Hi AndrewDMerrill,

Thanks for the detail explanation

The solution works when I changed the null rows using the below formula.

IIF(IsNull([X]),CharFromInt(160),[X])

But could you please explain how to do the other way using

replace nulls with non-collapsing character like no-break space U+00A0

Thanks

CoG

The CharFromInt(160) is the no-break space character. '00A0' in hex = 160 in base 10

Glad to be helpful!

binu_acs

@suby

Sample WF- Allignment.yxmd

suby

Hi AndreDMerrill,

When I use the below formula for the string Data type column this makes the column Null

IF(IsNull([X]),CharFromInt(160),[X])

But In my case there are other fields with Data type Int64 and Double

when I add the above formula for those Int64 and Double Data type column I get the below error

Error The formula resulted in a string but the field is numeric Use To Number.

Say if am not updating the Data type Int64 and Double columns with your formula then I am getting this in my output report but it works ok for string fields.

Any thoughts.

CoG

If you convert all fields to strings right before the final Formula Tool, then you should avoid the issue all together.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335