Simple LOAD ...GROUP BY - Invalid Expression

[chris1987]

Hi,

Please can someone point out where I'm going wrong with the below syntax.

It should be straight forward but I'm obviously missing something as I'm getting an "Invalid Expression" error, but no indication to why. All fields exist in the "QuoteInfo" table.

Cheers

Chris

Load upper("QLI_Ar-entity") & '|' & upper("Quote No") & '|' & upper("Quote Version No") as "QuoteKey",
"QLI_Ar-entity",
"Quote No",
"Quote Version No",
"QI_Quote-status",
SUM("QLI_calc-gross" * "QLI_Qty-orig-quo") as QuoteTotalGross,
SUM("QLI_calc-net" * "QLI_Qty-orig-quo") as QuoteTotalNet
Resident QuoteInfo
GROUP BY "QLI_Ar-entity","Quote No","Quote Version No";

[chris1987 · Accepted solution]

Spotted it the second I posted this question, I wasn't including "QI_Quote-status" in the group.

Thanks

Chris

Corrected:

Load upper("QLI_Ar-entity") & '|' & upper("Quote No") & '|' & upper("Quote Version No") as "QuoteKey",
"QLI_Ar-entity",
"Quote No",
"Quote Version No",
"QI_Quote-status",
SUM("QLI_calc-gross" * "QLI_Qty-orig-quo") as QuoteTotalGross,
SUM("QLI_calc-net" * "QLI_Qty-orig-quo") as QuoteTotalNet
Resident QuoteInfo
GROUP BY "QLI_Ar-entity","Quote No","Quote Version No","QI_Quote-status";