BloB data type
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A few questions:
You're converting a string to a geometry? What does the string look like? Im not sure convert to BLOB is thr right way of doing this...perhaps you can share a screenshot of data or provide a sample...
Also which database are you writing to?
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have attached a sample field, I want to import the Geometry field to the ODBC database.
I have the field currently as v_string. So I got the ODBC output error - doesnt support TEXT field. Then I used BloB convert which is a valid datatype in the ODBC connection, but the Create statement by Alteryx generates a Image type for the column rather than directly using BLOB file.
I am using firebird ODBC as destination.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome, this is exactly what I needed.
Alterrnatively, I created the DB Schema using RazorSql and then just inserted the data.But this is more automated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great news, gladto help.
