Table Format Error and Adjustment

Question

Hi Community

I would like to seek the help on the table formatting error in Alteryx as per the screenshot below. From the screenshot below, there is triangle at the top left of the cell and if i use the formula sum in the excel to calculate the number , it cannot be captured .

May i know if anyone know how to fix this in the Alteryx as i have multiple of rows but only this number have the issue. Is it because of the longer value? As you can see, the screenshot labeled number 2 have no error but screenshot labeled number 1 have this error.

Secondly, i would like to ask if we able to adjust the alignment to the left as i not sure why the alignment all to the right.

Lastly, is it possible that we add extra empty row and empty column as per the screenshot below?

I have also attached the sample workflow for your easier reference.

Back up AR 4.1.yxmd

Back up AR 4.1.yxzp

SH_94 · Answer

Hi @AdamR_AYX ,

Thank you for the help on the workflow.

I had tried to use the simple workflow to run the result and it is fine. I think it is because i use too many tools and complex workflow which cause the error. I would need to recheck all the tools that i used.

Secondly, i noted that we can't edit the table setting as it is grey background as per screenshot below. May i know how can we edit the table setting by enable it?

Thirdly, i try to analysis your workflow but have no clue what it want to do at certain stage. Could you please explain the purpose or the function on the three tools being used in this case?

AdamR_AYX · Answer

Hi @SH_94

I am unsure about your first question. Your attached workflows don't seem to have any data in so I can't run them. Are you able to create a smaller workflow that shows the problem that you can share?

I think the alignment you can just set in your table tool

Then for your third question it is possible but a little tricky. I've attached a sample workflow showing the technique

But the basic idea is to create some padding with a text tool and attach it to the left and above your table.

PadTable.yxmd