Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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);