topic question about data load using where function in QlikView

question about data load using where function

Anonymous — Wed, 18 Mar 2015 07:51:54 GMT

Hi,

While loading a table into the model from the data source I set a condition to load only those values of the field Brand whose name starts with symbol '?'. E.g. '? Brand1', '? Brand2'.

I've tried the following syntax: where Brand ='?*'

It doesn't work.

So, how should I define brands starting with symbol '?'?

Thank you in advance,

Larisa

Re: question about data load using where function

rubenmarin — Wed, 18 Mar 2015 08:19:51 GMT

Hi Larisa, maybe there is a better option but you can use:

where left(Brand, 1)='?'

Re: question about data load using where function

Fri, 24 Jul 2015 05:44:22 GMT

* INLINE [

    college,name, score

   ?a, 1, 50

   ?a, 2, 60

    ?b, 3, 70

   b, 4, 30

   b, 5, 30

   b, 6, 30



]

where Left(ltrim(college),1)='?';