Alteryx Designer Desktop Discussions

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

Create Spacial Points retrurning null value

AnnikaJ227
5 - Atom

Hello!

I am trying to find distances between two points.  When using the Create Points tool, I have quite a few records return null values.  I've spot checked a couple of lat/long values in Google maps and they are valid.  Any suggestions on what I may be doing wrong?

 

Thank you!

4 REPLIES 4
Hollingsworth
12 - Quasar
12 - Quasar

The lat/lon values look correct. Can you share a screenshot of how you have your Create Points tool configured?

John Hollingsworth
Clear Channel Outdoor
AnnikaJ227
5 - Atom

Sure!  Thanks for your help.

 

AnnikaJ227_2-1590679230374.png

 

 

AnnikaJ227_1-1590679189140.png

 

Hollingsworth
12 - Quasar
12 - Quasar

Please choose the Long field under the X Field (Longitude) dropdown and choose the Lat field under the Y Field (Latitude) field and rerun.

As configured, the coordinates describe a location not on planet earth and so the tool cannot create the points.

John Hollingsworth
Clear Channel Outdoor
AnnikaJ227
5 - Atom

Well.. I'm feeling pretty silly.  I'm not sure how/why I missed that. 

Thank you again for your help. 

Labels