ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Applying multi row formula to multiple columns

13 - Pulsar

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


Adjusting Alteryx Files for Different Versions


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,


12 - Quasar
12 - Quasar

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


Here's the tool mastery post for that tool

6 - Meteoroid

This worked! Thank you so much!

14 - Magnetar

This is exactly what I was after.

Thanks, @patrick_digan . You're a legend.



6 - Meteoroid

Thank you so much! My team had a line of addresses and contact info pulling from PDFs but when a contact had more than one location they werent always submitting info for both - so we were able to sort by the contact and say if empty fill the one before it - complete list now! just used 

IF ISNULL([ReportHeader])
THEN [Row-1:ReportHeader]
ELSE [ReportHeader]

Instead in the multi row. took us 2 days of failure before we found this--- again thank you!


5 - Atom

Many thanks. interesting solution and could be interesting for Alteryx to add a tool with this functionality in the near future.