question about data load using where function

[Anonymous]

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

[rubenmarin · Accepted solution]

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

where left(Brand, 1)='?'

[#3]

* 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)='?';