Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Larisa, maybe there is a better option but you can use:
where left(Brand, 1)='?'
Hi Larisa, maybe there is a better option but you can use:
where left(Brand, 1)='?'
* 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)='?';