BloB data type

nasrinahmed

I have used the BloB Convert tool to convert a string to a GEOMETRY,

now I am just outputting the file to an ODBC connection.

However in the create table statement I get the field is created as IMAGE type rather than a BLob type, how to rectify this?

chris_love

So for starters you do really need to be aware that Firebird isnt officially supported in Alteryx, so you may run into issues. That said I have used it sucessfully in the past.

In terms ofimporting your geometry field then Alteryx isn't converting the Create Table syntax properly, you need to specify this yourself.

I've attached an image of how you might do this taken from one of my colleagues modules doing this for producing geocoding maps for Tableau. Here you can see the settings he used (you need Transation size as 1 not 10000):

The key settings are options 3 and 5.

Please let me know how you get on.

Chris