Adding rows / values to an existing database load

[Anonymous]

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?

[OmarBenSalem]

You can create another table that contains:

Your column'SEATTLE1' and 2 other columns (lat and lon)

You'll then have 2 tables joined with the Seattle column:

table1:

load SEATTLE1,

field1,

field2,

field n

from table..;

table2:

SEATTLE1,

lat,

lon

from table2;

[Mark_Little]

Hi,

After you current load Add the below.

Left Join(Your table)

load * Inline

[

'Your Field', Lat, Lon

SEATTLE1, 1.2, 1.0

];

Replace Your table with the correct table name and 'Your Field' with the field name that contains SEATTLE1

Mark