Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
steeramp
Partner - Creator II
Partner - Creator II

Load with where condition from Resident table

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?

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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;

View solution in original post

2 Replies
alexpanjhc
Specialist
Specialist

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
Partner - Champion III
Partner - Champion III

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;