Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vincent_bellang
New Contributor III

Select loaded elements

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Select loaded elements

[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....

2 Replies
MVP
MVP

Re: Select loaded elements

[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....

sureshqv
Esteemed Contributor III

Re: Select loaded elements

you can try

Where match(Field1, 'Customer');