Can there be a SUM() function in the Preceding Load? It is not working for me. If not, why is that not allowed?

[#1]

Can there be a SUM() function in the Preceding Load? It is not working for me. If not, why is that not allowed?

Thanks!

[sunny_talwar]

Yes you can have Sum (with a group by statement) in preceding load.

[Kushal_Chawda]

Yes, you can write in preceding load. see this

Benefit of using Preceding load ..

[tresesco]

You can. You have to just be careful about the Group By clause. Try like:

Load

          Sum(Sales) as TotalSales

          Country

Group By Country;

Load

          *

From <>:

[Colin-Albert]

To use any aggregation in the load script; sum, count, max etc, there must be a "group by" clause.