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

[sunny_talwar]

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;

[annafuksa1]

Use just join

I have attach example

[surendraj]

Hi sunny,

could you please elaborate above solution.its bit confusion for me..

Thanks,

surendra

[sunny_talwar]

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

[sunny_talwar · Accepted solution]

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;

[Anonymous]

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..

[sunny_talwar]

But this doesn't seem like its meeting your requirement, is it?

vs. this

Or the required output had a typo?

[annafuksa1]

its a flag from which table data are coming, you do not need to use it

[Anonymous]

You are right, I edited my question!