This content has been marked as final. Show 4 replies
Hi, im still having a headach with using 'sum' in the load script. I am trying to generare the table below: -
I am trying to do the sum of 'no' grouped by Ref to produce and additional column that matches 'shouldbe'.
The code I am using is: -
(ooxml, embedded labels, table is Sheet1);
LOAD Ref as ref2,
sum([no]) as sum,
GROUP BY Ref , [no], shouldbe ;
DROP TABLE Main;
However the table that is being produced looks like this :-
I only want the load to produce one 'ref 1' with the sum being 14.
I'm baffled, any help would be greatly received.