Join 2 Tabels

[#1]

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

[martin59]

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>

[#3]

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

[#4]

Hi, Thanks,

attached QlikView