How to copy a column from one table to another?

[TrinidadCars John]

Good day all,

 

Once again I need some help:

 

I have a table with two of the columns being lat and long. I want to be able to copy those two columns to another table. The both columns from both tables have the same amount of rows.

 

Can some one give me a quick crash course on how this can be done?

 

John

[Ross Nixon]

Does the lat/long data belong to the records of the other table in the same sequence?
If there is an exact raw sequence match, you can do an SQL Select Query and join the tables by rowid. Then update two empty columns with the lat & long from the other table.
A join using a unique ID column is preferable, and that way the records don't need to be in the same sequence.

Ross

[TrinidadCars John]

I think it might be best if I set a unique ID for each row, but how can I do that?

John

[David Sherrod]

Not to rain on your plan, but why would you want to import positional data from another table?  Instead, create that data (new columns) for the objects in your table.  You can use Coordinate Extractor with the newer versions of Pro, or you can do it the old way by creating two new columns (lat, long) and then update table for centroid X and centroid Y. Here's the reason: the data in a column labeled latitude or longitude are not necessarily the coordinates for the assigned objects.  You can move an object, but the columnar data doesn't change.  (Unless you update the column.) If your goal is to have accurate lats and longs in columnar data, then do it within the table, not by importing data columns from elsewhere. Dave Sherrod --- On Fri, 6/14/13, TrinidadCars John <car.u...@gmail.com> wrote:

-- -- You received this message because you are subscribed to the Google Groups "MapInfo-L" group.To post a message to this group, send email to mapi...@googlegroups.com To unsubscribe from this group, go to: http://groups.google.com/group/mapinfo-l/subscribe?hl=en For more options, information and links to MapInfo resources (searching archives, feature requests, to visit our Wiki, visit the Welcome page at http://groups.google.com/group/mapinfo-l?hl=en   --- You received this message because you are subscribed to the Google Groups "MapInfo-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.

[Kannan Krish]

As Dave mentioned, not necessary to run something extra, instead create 2 more columns and update the lat/lon, if the files are the same.Hope that solves your issue..

--

KTG Infotech

GIS (Mineral Exploration)
Data Integration, Analysis, Capturing and Data Conversion
for Geochemistry,IP and Drill logs
Skypes-ktgcad