Select to view content in your preferred language

Event theme based on non-numeric fields

05-09-2017 05:16 AM
Regular Contributor II


We have a third party application with data stored in Oracle.  There is a table with text fields for east/north.

We want to create an Event Layer.  We cannot modify the table and as it is 3rd party don't want to add an Oracle view as it may mess with the support.

So, anyone any ideas if it is possible to cast/convert text fields within Desktop to create an event theme?



Tags (1)
0 Kudos
2 Replies
MVP Emeritus

you would have to add two new double fields and cast any text representations of numbers using 'float'.  You can't create an event theme directly from text, so you will have to edit the original file, add the fields or perform the operation on a new file

Regular Contributor II

I thought as much - we think we'll warehouse the data in SQL and do the conversion there. We don't like messing around in Oracle.


0 Kudos