Select loaded elements

[Anonymous]

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

[petter · Accepted solution]

[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

   Field1 LIKE '*Customer*';  // or maybe it should be Field1='Customer' for an exact match....

[Chanty4u]

you can try

Where match(Field1, 'Customer');