Sales State wise in Load Script

[Sameer9585]

Hi,

I have provided the data set which contains  ID,State,Sales and I need Sum of Sales State wise from the load script only.

Sheet 2 from the data set to be focused.

Thanks in advance,

[tresesco · Accepted solution]

Load
     State,
     Sum(Sales) as MonthlySales
Group By State;
Load
     *
From <>;