Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

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?

Tags (2)
1 Solution

Accepted Solutions

Re: Load with where condition from Resident table

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
Valued Contributor

Re: Load with where condition from Resident table

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);

Re: Load with where condition from Resident table

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