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: 
Not applicable

Inner join with where condition

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!

1 Reply
adnan_rafiq
Partner - Creator II
Partner - Creator II

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