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!

[mceleavey]

This is exactly what I was after.

Thanks, @patrick_digan . You're a legend.

M.

[JLMToth]

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]
ENDIF

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