topic Re: Join greater than in QlikView

Join greater than

Tue, 10 Jun 2014 14:19:52 GMT

Hi all,

I hope this is a smple question:

Is there a way to implement the following query in qlikview?

SELECT * FROM

TABLE_A A

INNER JOIN

TABLE_B B

A.Field1 > B.Field2

AND

A.Field3 < B.Field4

Thanks in advance.

Re: Join greater than

alexandros17 — Tue, 10 Jun 2014 14:22:50 GMT

Unfortunately Not directly, you need at first to join the tables with both fields then reload the resulting table and use a where condition as you need.

Re: Join greater than

its_anandrjs — Tue, 10 Jun 2014 14:37:10 GMT

Not with single table but you can use resident load for this and try with

tmpSource:

SELECT * FROM

TABLE_A A

INNER JOIN

SELECT * FROM

TABLE_B B

NewFinalTable:

Noconcatenate

Load * Resident tmpSource

Where

Field1 > Field2

AND

Field3 < Field4;

Drop Table tmpSource;

Re: Join greater than

alexandros17 — Tue, 10 Jun 2014 14:38:36 GMT

Inner join will let you lose records ... you need an (outer) join