1 Reply Latest reply: May 18, 2012 6:21 AM by Adnan Rafiq RSS

    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!

        • Re: Inner join with where condition
          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);