Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, need help on SUM function during load data it keep getting error on Invalid expression when I sum(score) as Point as per attached qvw file.
Thank you!
Hi Nic,
You need to use group by statement and all field names like below,
Student:
LOAD Student_name,
Category,
Score,
SUM(Score) as Point
FROM
[student_grade].xlsx
(ooxml, embedded labels, table is Sheet1)
Group by Student_name,Category,Score ;
Hi Nic,
Did you get the expected output.?
I get invalid expression error but I manage to solve it by adding resident load to perform sum.