Load with where condition from Resident table

[steeramp]

Hello ,

I one issue with Resident tables and Where conditions  !

I have 2 tables

TableA:

Load

A,

B,

C

From xxx.Qvd(qvd);

TableB:

Load

D,

E,

F,

G

From zzz.Qvd(qvd);

I want create one third table with this condition:

TABLEC:

LOAD

A*(D/E) as Quantity,

B as Material,

G as Unit

WHERE B=F AND C=G

Some ideas? Solutions?

[alexpanjhc]

try:

TableA:

Load

A,

B,

C,

B&C as Key

From xxx.Qvd(qvd);

left join(Table A)

TableB:

Load

D,

E,

F,

G,

F&G as Key

From zzz.Qvd(qvd);

[Peter_Cammaert · Accepted solution]

Or this:

InitialData:

LOAD B AS Material,

     C AS Unit,

     A

FROM xxx.Qvd(qvd);

INNER JOIN (InitialData)

LOAD F AS Material,

     G AS Unit

     D / E AS Z

From zzz.Qvd(qvd);

TableC:

NOCONCATENATE

LOAD Material, Unit,

     A*Z as Quantity

RESIDENT InitialData;

DROP Table InitialData;