Garbage after expression : "url"

[sspawar88]

Hi Community,

I have straight table in which written expression is like:

=[ID]& if('$(IsUat)'>0,'$(vULINK)', '$(vPLINK)')

Varibale-->

IsUat -->to pick up the environment like UAT or PROD

vULINK-->if (schema='A', '<url>link1,if (schema='B','<url>link2'));

vPLINK--> if (schema='A', '<url>link1,if (schema='B','<url>link2'));

It gives Garbage after expression : "url" error on straight table.

[olivierrobin]

i think the ending quotes are missing

if (schema='A', '<url>link1',if (schema='B','<url>link2'))

same for plink

[balabhaskarqlik]

You missed the ending Quotes in both variable declarations.

Those variables, should be like:

vULINK-->if (schema='A', '<url>link1',if (schema='B','<url>link2'));

vPLINK--> if (schema='A', '<url>link1',if (schema='B','<url>link2'));

[sspawar88]

No that mistake I made while writing the query. plz have a look again

[sspawar88]

No that mistake I made while writing the query. plz have a look again