Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there an equivalent of Sum(total column) in Data Load Editor script.
I want to get the value of Expression - Sum(total MktVal) in the Loading script.
I can get the result of 5,769.03 in Table (shown below) when I add it as an Expression, but that is not what I am looking for...
Please see below example -> clearly below script is wrong, because I am Grouping using Cusip.
Without Grouping, it gives me incorrect formula error.
SecData:
LOAD * inline [
Cusip|Qty|Price|MktVal
cusip1|545|99.3|541.19
cusip2|742|96.2|713.8
cusip3|865|100.9|872.79
cusip4|600|98.6|591.6
cusip5|772|95.7|738.8
cusip6|756|96|725.76
cusip7|876|96.5|845.34
cusip8|721|102.6|739.75
] (delimiter is '|');
MVTotal:
Left Join (SecData)
Load Cusip,
Sum(MktVal) as TotMktVal
Resident SecData
Group by Cusip;
This should be a very simple solution, but I am unable to arrive at that.
Could you help
Thanks
What if you don't group By and do like this -
MVTotal:
Left Join (SecData)
Load
//Cusip,
Sum(MktVal) as TotMktVal
Resident SecData
//Group by Cusip;
;
What if you don't group By and do like this -
MVTotal:
Left Join (SecData)
Load
//Cusip,
Sum(MktVal) as TotMktVal
Resident SecData
//Group by Cusip;
;
Many thanks..