Where in table inline

[#1]

Hi, I do this and works well

Ciudades:

LOAD * INLINE [

    Ciudad, Valor

    Barcelona, X

    Tarragona, M

    Lleida, N

    Girona, P ] where Ciudad='Barcelona' ;

But, if change 'Barcelona' by variable, malfunctions

LET var='Barcelona';

Ciudades:
LOAD * INLINE [
    Ciudad, Valor
    Barcelona, X
    Tarragona, M
    Lleida, N
    Girona, P ] where Ciudad=$(var);

Can help me?

Thanks...

[pat_agen · Accepted solution]

hi,

try simple quotes around the variable

Servidor='$(var)'

[erichshiino]

Try this:

Ciudades:

LOAD * INLINE [

    Ciudad, Valor

    Barcelona, X

    Tarragona, M

    Lleida, N

    Girona, P ] where Servidor='$(var)';

( ... but it is a bit strange that you used where since you wrote the inline yourself...)

Hope it helps,

Erich

[#4]

Thanks a lot, Pat and Erich