Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Is it possible to add square brackets in LoadScript?
Here's my sample code but this throws error "Garbage after statement"
[Code]
Load * Inline [
Formula, Value
NetSales, Sum([Net Sales])
];
[/Code]
Any Idea?
Thanks in advance!
Ronald
To my knowledge it is not possible to use square brackets in an inline load. I think you would have to do this in two steps.
raw:
LOAD * Inline [rich:
LOAD
FIELD1,
Sum([VALUE])
Resident raw
Group By FIELD1;
DROP Table raw;
Or, simply don't use spaces in your fieldnames. That way you don't need square brackets.
Hi olafjoppe,
Thanks for the response!
Yes its not possible to add a square brackets I used quotes instead and now its working fine!
Load * Inline [
Formula, Value
NetSales, Sum("Net Sales")
];
Regards,
Ronald
How about using variables where the value is set to the expression?
Depending on how you use it you may need to include an aggregation over any chart dimensions.
Regards,
Gordon