Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

chkelley
New Contributor III

Adding rows / values to an existing database load

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?

2 Replies
omarbensalem
Esteemed Contributor

Re: Adding rows / values to an existing database load

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;

mark6505
Valued Contributor III

Re: Adding rows / values to an existing database load

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