Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a variable vQuoted. It contain the values '02502028','22001206'
I'd like to use a calculated dimension and have done the below. Portfolio is another dimension
The below gives an error
=if(portfolio = $(vQuoted),'Quoted','Unquoted')
I did also try the below which didnt give an error but it doesnt calculate the variables
=if(portfolio = vQuoted,'Quoted','Unquoted')
Can you please help
Paul
Thanks for your help
I dont really understand the inline thing but i did think the idea of doing in the script was good, so i created a new dimension and that worked
if(match(portfolio,'02502028', '22001206')>=1, 'Quoted','Unquoted') as portfolio_quoted,
Thanks for your help
You can solve this at load time (script)...
SET vQuoted = 02502028, 22001206;
Test:
NOCONCATENATE
LOAD *, If(Index('$(vQuoted)', Portfolio), 'Quoted', 'Unquoted') AS Dim
INLINE [
Portfolio,
02502028
22001206
22001207
];
Use Dim field (From Script). Otherwise, add calculated dimension (FRONTEND).
Thanks for your help
I dont really understand the inline thing but i did think the idea of doing in the script was good, so i created a new dimension and that worked
if(match(portfolio,'02502028', '22001206')>=1, 'Quoted','Unquoted') as portfolio_quoted,
Thanks for your help