Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Input and Output Spatial Objects from/to .SQLITE files

I have a big need to input files created in a .sqlite format and also write out to files as .sqlite that contain spatial object fields.  Currently they are not recognized as spatial objects.  BlobConvert is not able to convert the spatial fields from the input correctly (it gets close) so the result is that we are unable to utilize any spatial fields from or to these files.

2 Comments
sphwillis
7 - Meteor
you can convert them in QGIS to SHP format which can be read by Alteryx. commandline tool like OGR may work too. 
http://docs.qgis.org/

Simon
NickPa
Alteryx Alumni (Retired)

Hi,

 

Typically users are storing spatial data in SQLite for mobile use cases.  Can you please elaborate the data (stored as sqlite) that you're intending to bring into Alteryx, what you will do with that data, and then downstream use of that exported SQLite data?  We need more context before we can research this further.


Thanks