Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try to aggregate them like below script.
Load Date,
Country,
Count(Order#) as OrderQty
From xyx
Group by Date,Country
Regards,
Kaushik Solanki
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;