topic Re. :Join 2 Tabels in QlikView

Join 2 Tabels

Tue, 11 Jan 2011 16:21:27 GMT

Hello,

how can I create ResultTabelle from Tabelle1 and Tabelle2

Tabelle1:

Material_ID1,

Date_MonthYear,

Sales1,

Rolling,



Material_ID1 DateMonthYear Sales1 Rolling
111111 Jan-2010 1 Jan-2010
 - Feb-2010
 - Mar-2010
 - Jun-2010
 - Aug-2010
 - Sep-2010
 - Okt-2010
 - Nov-2010
 - Dec-2010

Tabelle2:

Material_ID2,

Rolling,

Sales1,


Material_ID2 Rolling
111111 Feb-2010 8 Feb-2010

ResultTabelle:

Material_ID1,

Date_MonthYear,

Sales1,

Rolling,

Sales2,



Material_ID1 DateMonthYear Sales1 Rolling Sales2
111111 Jan-2010 1 Jan-2010
 - Feb-2010 8
 - Mar-2010
 - Jun-2010
 - Aug-2010
 - Sep-2010
 - Okt-2010
 - Nov-2010
 - Dec-2010

Thanks

Re. :Join 2 Tabels

martin59 — Tue, 11 Jan 2011 16:29:48 GMT

Hi,

You have to do something like this :

ResultTabelle
LOAD
Material_ID1 as Material_ID,
Date_MonthYear,
Sales1,
Rolling
FROM Tabelle1;

JOIN (ResultTabelle)
Material_ID2 as Material_ID,
Rolling,
Sales1 as Sales2
FROM Tabelle2;<div>

Re. :Join 2 Tabels

Tue, 11 Jan 2011 16:42:51 GMT

Hello,

Thanks, but the add one line with the Date_Month as '-' and Rolling Feb-2010.

i would like add sales in the exist line:


Matrial_ID Date_MonthYear Sales1 Rolling Sales
111111 Jan_2010 1 Feb_2010 8

Thanks

Re. :Join 2 Tabels

Tue, 11 Jan 2011 17:04:01 GMT

Hi, Thanks,

attached QlikView