Unable to render a file with 105 columns as equally spaced

Question

After applying few operations on a data finally while rendering it into an excel, I found the output file formatted in the way as shown in the screenshot. But while seeing the same table on browse tool in alteryx I find it perfectly formatted. What am I missing here? Help from the community will be grateful

image (2).png

image (3).png

SuthierRamasamy · Answer

Thanks for the clarification on Browse and the actual render. As per your suggestion I tried changing all the 3 formats (Fixed (15), Automatic and Percentage (100%)) still my output looks the same. The version I'm using is 2022.3.1.450. Not sure if it has something to do with the version but just in case putting out here.

OTrieger · Answer

@SuthierRamasamy 
You need to remember that when you look at the data with Browse tool is gives you a preview of the data not how it will be render out as in Alteryx you do not have a limit of the size of the output, so it look nicely and evenly as if you would have the data in Excel, however that is not the case with the render.

You will need to set the render tool with a Custom output size and then modify it as needed, then you could see that the output columns will start getting wider and wider. But still they width will not be equal as in Excel but based on the content in the cells.

If I'm not wrong you can set a fixed size for the different items on the table in the Table tool, which is set by default to automatic.