Why is this preceding load not working

[#1]

gets me the following error

Invalid expression

Data:

Load * Inline [

User, Doc

Holden,AR

Holden,SA

Holden,IA

Holden,ED

Holden,CS

Aaron,CS

Brent,AR

Brent,SA

Brent,IA

Brent,ED

]

Any help appreciated, thanks

[swuehl]

If you want to use aggregation functions like Sum() in your LOAD, you need to use a GROUP BY clause for all fields that are not embedded in aggregation functions.

[sasiparupudi1]

You can not have aggregations in the preceeding loads.

change it to a resident load using the necessary group by statements.

finaltype is the problem as it is a result of aggregation

hth

Sasi

[#4]

I'm not sure I understand.

The following script is still returning errors.

[#5]

Okay, I did this resident load, and it works except the last sum = 3, for Admin doesn't show up

[swuehl]

Your top most star symbol will consider Type field as field which is not included in the GROUP by clause.

[Clever_Anjos]

Dont use * into your first load but

load

User,

Doc,

sum.....

[swuehl]

Your second load only creates 2 distinct values at most.

[#9]

Ahk, youre right. Same issue though, the admin where type sum = 3 isnt showing up

[sasiparupudi1]

I do not see a condition for type value 3 in your logic?