This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@k_speik this might help in the future. Can be used for any object type, workflow, macro, etc
Adjusting Alteryx Files for Different Versions
@patrick_digan Thanks very much!
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
@jeanvaladez, you can absolutely do that with a multi-field formula.
Here's the tool mastery post for that tool
This worked! Thank you so much!
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!