2 Replies Latest reply: Nov 2, 2017 11:23 AM by Mark Little RSS

    Adding rows / values to an existing database load

    Chris Kelley

      We have a database we are pulling from. It has columns which describe in a basic sense the data to a reasonable level of granularity. For instance, I know particular data is coming from a site called SEATTLE1. Now, I also know, separately, the latitude and longitude of SEATTLE1. I want to insert a new column for latitude and another for longitude in the load script. For each record of SEATTLE1 in the load, I want to insert the corresponding latitude and longitude values into that row.

       

      How can this be accomplished?