Designer| Table tool ; Formatting

Question

Hi All - I have a dataset with 300+ columns/fields which are numeric, rounded to three decimals using a formula tool to be precise. This needs to be formatted with basic font size, borders etc. As far as I'm aware "table tool" is the best way to do so. However, by default the table tool changes the decimal places to 0, and it is impossible to change each field parameter to 3 decimal places.

Is there a way to either

1. Achieve desired formatting on excel output tool (or)

2. fix the decimal places issue on the table across all fields

Attached input file where columns B till end needs to fixed to 3 decimal places in the table tool without manually clicking on fields and inputting 3.

Please note that I have Alteryx 2019.4 and cannot upgrade. Due to this, using a existing template which is available in 2021 version is not possible, Any suggestions please?

test_pp.xlsx

Mj9715 · Answer

@messi007 sorry if I wasn't clear. I'm aware of this feature in table tool.. however I have over 300 fields and its impossible to click on each field name and change decimal places to 3 on the table tool.

To give you an example, all columns in attached file from B onwards need to be fixed to three decimal as the table defaults to zero decimal places.

test_pp.xlsx

messi007 · Answer

@Mj9715,

With table tool you can change the format to 3 decimal place :

Below the result:

Attached the sample workflow for test.

Regads

Format_20210410.yxmd