Set text in report export to be middle-aligned horizontally

I'm trying to set my table export from Alteryx to be middle-aligned horizontally. In Excel this is a quick fix to just click on "Middle Align".

I'm able to see that in the table tool there is the option of "Alignment (H)" and "Justification" . These are both set to "Center" however it does not appear to be working.

What am I missing?

Thank you!

Accepted answers

All comments

apathetichell

Hi - can you double check that the column Alignment in Table is actually set to center? Click on the column name under Per Column rule and make sure that they are set to center... Even though the overall Table was grey-ed out as center, when I clicked on each column, I had to manually reset it as center.

I tried it under browse and exporting to .pdf right now - and didn't have a problem altering the alignment in either. What are you rendering to?

kevinclark

I'm rendering to Excel. Please see the example attached. Row is set to align center and then justification too.

Row Alteryx Example.PNG

Row Formatting 2.PNG

Row Formatting.PNG

pedrodrfaria

Hi @kevinclark

Can you show us how the output looks like in the excel file? The configuration looks to be correct.

I also attached a simple WF to show you how the proper set up is, this way you can double check it.

Pedro.

Set text in report export to be middle-aligned horizontally.yxmd

kevinclark

Hi @pedrodrfaria

In your example the vertical alignment is working but not horizontally. Once the row height is expanded it shows aligned on the top.

I'm using version 2020.2.3. Not sure if this has been addressed in the newer versions.

Please see my attachments.

Thanks!

Excel example.PNG

Excel desired output.PNG

BenMoss

Hi,

It's possible to vertical align by using the 'formula' mode in the table tool with the following statement...

"vertical-align: middle;"

You can then use the justification to get your horizontal allignment correct.

This image shows how I have set this up in the past.

Ben

JoeHodgetts

Thanks Ben - this works well (make sure to select Header & Data to make it apply to the whole column 🙂 )

Joe

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703