topic Re: generate a new column on a table in Data Management Questions

generate a new column on a table

johnwoollett1 — Tue, 29 Nov 2016 15:36:17 GMT

I have a data table and want to perform an sql query to build a new column on the data containing data from several data columns, how can this be done?

eg IF(FIND('-',Location_Code)=4, LEFT(Location_Code, 12), LEFT(Location_Code, 13))

thanks john woollett

Re: generate a new column on a table

AdrianWelsh — Tue, 29 Nov 2016 15:39:34 GMT

John,

What format is your data table in? What software are you using for running this SQL query?

In any case, take a look at the info here. This might help:

Building a query expression—Help | ArcGIS for Desktop

Re: generate a new column on a table

johnwoollett1 — Tue, 29 Nov 2016 15:56:51 GMT

Its in an oracle database, I want to reproduce a Functional Attribute from an Intergraph geoworkspace.

I need to use FIND,LEFT,RIGHT functions to compile the result

thanks

Re: generate a new column on a table

AdrianWelsh — Tue, 29 Nov 2016 23:11:46 GMT

John,

You may get better luck placing this thread in Enterprise GIS‌ or ArcGIS for Server‌. Having oracle tags in it would help as well.