Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
To get those null rows which won't created by a simple join
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