Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Applying multi row formula to multiple columns

Highlighted
12 - 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
5 - Atom

@patrick_digan  Thanks very much!

6 - 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

Highlighted
11 - Bolide
11 - 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
6 - Meteoroid

This worked! Thank you so much!

Labels