Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Shortening latitude and longitude data to 5 decimal places?

Highlighted
5 - Atom

I have latitude and longitude data that goes out to 10 or 15 decimal places, and I'm trying to narrow it down to 5 decimal places. What tool do I use? The formula node? What expression should I be using to accomplish this?

 

Thank you in advance,

 

haro5971

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
A formula of round([latitude],0.00001) would do it.
Highlighted
Alteryx Alumni (Retired)

Or if you are looking to just truncate it, you can drop in a Select tool and change the data type to Fixed Decimal and indicate the number of decimals.

Highlighted
5 - Atom

Beautiful, it worked! Thank you so much.

Labels