Applying multi row formula to multiple columns

[ChrisTX]

@k_speik this might help in the future. Can be used for any object type, workflow, macro, etc

Adjusting Alteryx Files for Different Versions

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versio...

[k_speik]

@patrick_digan  Thanks very much!

[jeanvaladez]

Hi Josh,

I am trying to follow your example for a similar objective. However, I want to round all of my values in each column to a whole number (i.e. with out any decimals). I have been doing this by using the Formula Tool and using the following formula for each column: 

"Round([ColumnName], 1)"

I would like to do this in a faster and much more efficient way as I now have over 100 columns and do not want to set up the Formula for each one of them.

Can I do this without having to type out the formula for each column using your example below?

Thank you,

Jeanette

[jarrod]

@jeanvaladez, you can absolutely do that with a multi-field formula.

Here's the tool mastery post for that tool

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Field-Formula/ta...

[jeanvaladez]

This worked! Thank you so much!