Alteryx Designer Desktop Discussions

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

Shortening latitude and longitude data to 5 decimal places?

haro5971
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

3 REPLIES 3
chris_love
12 - Quasar
A formula of round([latitude],0.00001) would do it.
RodL
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.

haro5971
5 - Atom

Beautiful, it worked! Thank you so much.

Labels