Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create this table but I've got some problem with syntax.
newdimension:
LOAD * INLINE [
newdim,
"if(sum([Importo Effetto]>$(soglia7),'A','')"
];
Any help ?
Many thanks
Marco
Hi,
Just get rid of the extra double quotes and use chr(34):
newdimension:
LOAD * INLINE [
newdim,
chr(34) & if(sum([Importo Effetto]>$(soglia7),'A',' ') & chr(34)
];
Hope this helps.
Hi Marco, the brackets of the field name will be interpreted as the en of the Inline table, you can also name the field with double quotes:
LOAD * INLINE [
newdim
if(sum("Importo Effetto">$(soglia7),'A','')
] (delimiter is ';');
If you need both, brackets and double quotes you can also use the ` simbol to enclose the Inline sentence and double-double quotes to force Inline to load the double quotes as part of the string:
LOAD * INLINE `
newdim
""if(sum([Importo Effetto]>$(soglia7),'A','')""
` (delimiter is ';');
With your script I've got some error :
This is the result :
any suggestion ?
Thanks
Hi. With both script I've got this result
I expected a value as result.
Any suggestion ?
Thanks
try this
LOAD * INLINE "
newdim
if(sum([Importo Effetto]>$(soglia7),'A','')
";
Hi,
May be Like this..
newdimension:
LOAD Replace(Replace(newdim,'|','$'),'^',',') as newdim;
LOAD * INLINE "
newdim,
if(sum([Importo Effetto]>|(soglia7)^'A'^'')
";
Hi Marco, to evaluate the expression you can use the $-expansion, please follow the attached example.
BTW, I added a parenthesys to close the Sum()
wich example ?
The attached qvw:
The first list box has the newdim expression evaluated