Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Applying multi row formula to multiple columns

Highlighted
Quasar

@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...

 

Highlighted
Atom

@patrick_digan  Thanks very much!

Highlighted
Meteoroid

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

Bolide
Bolide

@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...

Highlighted
Meteoroid

This worked! Thank you so much!

Labels