Make Query Table - Field conversion

Discussion created by cmatthews on Feb 21, 2014
Latest reply on Feb 27, 2014 by jamesfreddyc

I'm creating a model that is sucking in data from an Oracle database, which I intend to turn into an Event Layer.

Usually this is pretty simple, however on this occation the X and Y coordinates have been stored as strings.

Is it possible to convert field data types when bringing in the data with the Make Query Table tool. Clearly if I was using straight SQL to the database I could do that)?

All help and suggestions appreciated.