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

Applying multi row formula to multiple columns

ChrisTX
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

 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versio...

 

k_speik
5 - Atom

@patrick_digan  Thanks very much!

jeanvaladez
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

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

jeanvaladez
6 - Meteoroid

This worked! Thank you so much!

mceleavey
14 - Magnetar

This is exactly what I was after.

Thanks, @patrick_digan . You're a legend.

 

M.

JLMToth
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!

 

Sergio_Avalos
5 - Atom

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

Labels