Reduce data loaded

[Anonymous]

Hello Everyone!

I know what Im goign to ask is possible as someone once told me but I dont know how.

Basically. I have a file with many raws, lets imagine each raw is a purchase order list and every column is more information about each order(date, country, etc).

Can I load all the table, to later create a simplified version of it(using the script), lets says total order per day, and eliminate all the previous data loaded, as I dont need so much detail, with the goal of making my report faster and lighter?

Hope the next image helps you get my question.

[kaushiknsolanki]

Hi,

Try to aggregate them like below script.

Load Date,

        Country,

        Count(Order#) as OrderQty

From xyx

Group by Date,Country

Regards,

Kaushik Solanki

[settu_periasamy]

Try this..

T1:
Load [Order #], Date, Country From Source;

NoConcatenate

Final:

Load Date,Country,Count([Order #]) as [Order Qty] Resident T1 Group by Date,Country;

Drop Table T1;