topic Join 2 tables?? in QlikView

Join 2 tables??

Fri, 12 Nov 2010 10:50:40 GMT

Ik would like to create one table from the 2 following tables, 1 table is a db table, the other is a inline txt table

How can i create one table of these 2?

Join 2 tables??

marcel_olmo — Fri, 12 Nov 2010 11:21:45 GMT

Hi Jochen, is as easy as do a left join of the main table.

Here is an explicit example of your code to get a join of your 2 tables. It's tested. Hope it works!!

Table1 :

load * inline [
latitude,LONG_LAT_KEY,longitude
52.3181,230,6.528677
52.21943,140,6.97347
52.23361,130,6.84428
52.34075,210,6.628083
52.38505,170,7.032141
52.179942,260,6.714258
52.203206,200,6.644945
52.247845,150,6.57294
52.261632,160,7.014019
52.279025,80,6.773913
52.308762,100,6.892506
52.365802,10,6.652021
52.371228,240,6.469322
52.407397,30,6.631098
52.408698,50,6.767461
52.414545,180,6.919015
52.446837,190,6.565589
52.454065,40,6.616365
52.462387,250,6.496274
,60,
,70,

];

left join (Table1)

Table2 :
load * inline [
LONG_LAT_KEY,TTT
10, Almelo-V
30 ,Vriezenveen
40, Westerhaar
50, Tubbergen
60, Weerselo
70, Delden
80, Hengelo
100,
130,
140,
150,
160,
170,
180,
190,
200,
210,
230,
240,
250,
260,
];

Join 2 tables??

Fri, 12 Nov 2010 12:00:49 GMT

the table O_Realisatie is a db-table with facts (6.000.000 records) so no inline table, the other table is a inline table, like to make 1 one fact table with facts and longitude and latitude.

Join 2 tables??

marcel_olmo — Fri, 12 Nov 2010 12:04:57 GMT

I don't mean it to do it with inline tables, I don't understand you.

What I'm trying to show you is that you have to do a left join (mainTableName) before the second table you want to join.

This is the solution.

Cheers!

Join 2 tables??

Fri, 12 Nov 2010 14:18:56 GMT

Thnx i understand the given solution.

I changed the document and it works!