Event theme based on non-numeric fields

141
2
05-09-2017 05:16 AM
Highlighted
Regular Contributor II

Hi

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?


Cheers

ACM

Tags (1)
Reply
0 Kudos
2 Replies
Highlighted
MVP Esteemed Contributor

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

Highlighted
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.

Thanks

Reply
0 Kudos