2 Replies Latest reply: Jul 24, 2018 1:23 PM by Chanty 4u RSS

    Select loaded elements

    Vincent Bellanger

      Greetings,

       

      I'm having trouble selecting data i need from a file. I'm importing my data from an xls file and i want to select data who only have like 'Customer' in Field1. I tried with 'where exists' but i did not succeed in making it work, here is what i've so far

       

      [Table]:

      LOAD

      Upper(Field1) AS Field1,

      Upper(Field2&' '&Field3) AS Field2;

      LOAD Field1,

      Field2,

      Field3

      FROM [data.xls]

      (biff, embedded labels, table is ExcelMergeQuery$) where exist (Field1, 'Customer');