Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vincent_bellang
Contributor III
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
petter
MVP
MVP

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

View solution in original post

2 Replies
petter
MVP
MVP

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

View solution in original post

Chanty4u
Champion III
Champion III

you can try

Where match(Field1, 'Customer');