Help in SUM Function during Load Data

[nicholas5141]

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!

[tamilarasu]

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 ;

[tamilarasu]

Hi Nic,

Did you get the expected output.?

[nicholas5141]

I get invalid expression error but I manage to solve it by adding resident load to perform sum.