Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?


Pulling Polygon From MySQL as Blob


We have a database with a bunch of polygons stored that I would like to be able to grab. They are all in blob format, and I'm not sure how to convert that to a SpatialObj in Alteryx. Blob Convert tool so far doesn't seem to be helping much. 


Blob convert can convert it to Base64 binary data and it spits out a string like "AAAAAAEDAAAAAQAAAAcAAAC7Dz3v2mhUwPJXuOSNhURA0BKX1ExfVMAehsAEuHlEQD5woizKUlTA


but from there I'm stumped. Anyone done this before? Thanks!

Alteryx Partner

I'm having the exact same problem.  Did you ever get resolution?



I never did, and I'm only just now realizing that this post is a whole year old!


I've seen some simple examples about converting to PNG, GIF, JPG to and from blobs, but nothing about spatial objects.


Just now I tried using a a spatial object converted to a string (through a quirk in one of the R-tools) with the blob convert tool, but there doesn't seem to be a way to get that back to a spatial object? Sadly I'm no closer. Now you've perked up my curiosity (and annoyance), so I'll play around with it a bit more today, with luck we'll figure it out. 

Alteryx Partner

Thanks for getting back to me.  I'll let you know if I make any progress toward a resolution.