Inner join with where condition

[#1]

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!

[adnan_rafiq]

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