Spatial data not coming through when queried
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rob-k
7 - Meteor
05-13-2024
12:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm having issues with loading spatial data into Alteryx from SQL Server. If I put anything in the WHERE part of the query the Spatial type column comes through incorrectly - see image below.
If I leave WHERE empty then Spatial columns are loaded without any issues.
I've tried troubleshooting it but have been unsuccessful so far. Any advice on how to fix this would be much appreciated.
Thanks,
Labels:
- Labels:
- Spatial Analysis
3 REPLIES 3
aatalai
14 - Magnetar
05-13-2024
12:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
05-13-2024
01:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I do if my data is a point. Most of the time i'm looking at Polygons.
alexnajm
17 - Castor
05-13-2024
04:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Are you using an OleDB connection? That seems to be the fix according to this: https://knowledge.alteryx.com/index/s/article/Spatial-Data-from-SQL-Server-shows-up-as-None-Null-or-...