Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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