topic Re: Load with where condition from Resident table in QlikView

Load with where condition from Resident table

steeramp — Tue, 27 Sep 2016 10:37:34 GMT

Hello ,

I one issue with Resident tables and Where conditions !

I have 2 tables

TableA:

Load

From xxx.Qvd(qvd);

TableB:

Load

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?

Re: Load with where condition from Resident table

alexpanjhc — Tue, 27 Sep 2016 17:38:39 GMT

try:

TableA:

Load

B&C as Key

From xxx.Qvd(qvd);

left join(Table A)

TableB:

Load

F&G as Key

From zzz.Qvd(qvd);

Re: Load with where condition from Resident table

Peter_Cammaert — Tue, 27 Sep 2016 18:52:05 GMT

Or this:

InitialData:

LOAD B AS Material,

C AS Unit,

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;