Inner join with where condition

Fri, 18 May 2012 09:39:35 GMT

Hello,

I just would like to join these two tables, with the following condition: where result > min and result < max. So I just would like a table with all the fields with that condition working. The result will be a table with only 3 rows...

Can anyone help me ?

Thank you!

Re: Inner join with where condition

adnan_rafiq — Fri, 18 May 2012 10:19:41 GMT

Try this I hope this would work

Directory;

LOAD Ziel_ID,

min,

max,

result

FROM

C:\Users\Adnan\Downloads\Mappe1.xlsx

(ooxml, embedded labels, table is Tabelle2) Where purgechar(result,'ZE_') > min and purgechar(result,'ZE_') < max;

inner join

LOAD Ziel_ID,

Istwert

FROM

C:\Users\Adnan\Downloads\Mappe1.xlsx

(ooxml, embedded labels, table is Tabelle1);

topic Re: Inner join with where condition in QlikView

Inner join with where condition

Re: Inner join with where condition