Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In URL/Expression window I have this (simplified url) and this works
='http://mycompany.net/jump.ashx?employeeId=' & [Employee Id]
I’m going to use this in 10+ places so like to put this in a Script variable
Cannot figure out the syntax for referencing the dimension in a script variable, so I created a script variable for the dimension, Employee Id
In Script
vEmpId ='[Employee Id]';
in the URL/Expression Window, the variable works
='http://mycompany.net/jump.ashx?employeeId=' & $(vEmpId)
But when I tried to put that statement into the script format and I cannot figure out how to do it
varURL = ='http://mycompany.net/jump.ashx?employeeId=' & '$'&' (vEmpId);
varURL = ='http://mycompany.net/jump.ashx?employeeId=' & chr(36) & (vEmpId);
Surprisingly I am getting a lot of
Thanks in advance
Will bring this to different places in the front-end view? Perhaps bringing it as a field might already be what you're looking for.
Table:
LOAD
A
B...,
'http://mycompany.net/jump.ashx?employeeId=' & [Employee Id] as URL
FROM [lib://] (qvd) ;
Regarts, Matheus
thank you for the suggestion! Though, probably don't want to go with that route as I don't want to clutter 10+ tables with the URL address. I'll just continue with the expression.