Combining Tables

[Anonymous]

Hey,

I have a problem with combining two tables which I have as QVD-Files.

For better understanding I create these two tables:

Table1:

LOAD * INLINE [

    Auftr,      KdNr

    1,           aa,

    2,           cc,

    3,           ee,

];

Table2:

LOAD * INLINE [

    Auftr,      LSNr,      Date

    1,           xx,           10,

    1,           zz,           12,

    3,           yy,           11,

];

What I want to have is a new table with the following content:

	AuftrNr,	KdNr,	LsNr,	Date
	1,	aa,	--,	--,
	1,	aa,	xx,	10,
	1,	aa,	zz,	12,
	2,	cc,	--,	--,
	3,	ee,	--,	--,
	3,	ee,	yy,	11,

I tried many different join as well as concatenate approaches but never got the correct result.

Can someone help me?

BR,

Emanuel

[Anonymous]

Thank you for your answer Sunny, this is what I was looking for

But one question, probably stupid one.

Why do I have to load these two columns of my table DISTINCT?

[sunny_talwar]

To get those null rows which won't created by a simple join

[annafuksa1]

an I use them to avoid concatenation (if you have 2 exactly the same tables, Qlikview will concatenate them) and as I was planing to work on temporary tables (as inline are a little limited) I create this flags