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
Can be simplified to this
Table1:
LOAD * INLINE [
Auftr, KdNr
1, aa,
2, cc,
3, ee,
];
Join (Table1)
LOAD * INLINE [
Auftr, LSNr, Date
1, xx, 10,
1, zz, 12,
3, yy, 11,
];
Concatenate (Table1)
LOAD DISTINCT Auftr,
KdNr
Resident Table1;
DROP Table Table2;
May be like this:
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,
];
Join (Table1)
LOAD *
Resident Table2;
Concatenate (Table1)
LOAD DISTINCT Auftr,
KdNr
Resident Table1;
DROP Table Table2;
Use just join
I have attach example
Hi sunny,
could you please elaborate above solution.its bit confusion for me..
Thanks,
surendra
Elaborate what? What part of the script do you not understanding? Its seems like a straight forward script, unless you have specific thing you don't understand
Best,
Sunny
Can be simplified to this
Table1:
LOAD * INLINE [
Auftr, KdNr
1, aa,
2, cc,
3, ee,
];
Join (Table1)
LOAD * INLINE [
Auftr, LSNr, Date
1, xx, 10,
1, zz, 12,
3, yy, 11,
];
Concatenate (Table1)
LOAD DISTINCT Auftr,
KdNr
Resident Table1;
DROP Table Table2;
Hey Anna,
your answer is the easiest to understand for me (sorry I'm a newby )
But I don't understand the meaning of "1 as flag", can you explain it for me.
Edit:
Unfortunately, the results are not correct..
But this doesn't seem like its meeting your requirement, is it?
vs. this
Or the required output had a typo?
its a flag from which table data are coming, you do not need to use it
You are right, I edited my question!