Alteryx Designer Discussions

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

Applying multi row formula to multiple columns

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

 

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

12 - Quasar
12 - Quasar

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

6 - Meteoroid

This worked! Thank you so much!

Alteryx Certified Partner

This is exactly what I was after.

Thanks, @patrick_digan . You're a legend.

 

M.

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

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

 

Labels