Yes, I have. You can use order by e_id, cus, ta, compute sum(col4), sum(col5) by e_id, cus, ta.
I want to know if you can do it in Perl. I know there is a way to achieve the shown data structure because I did it once before with a stock file. Unfortunately, I can't figure it out this time and I can't find the code.
| [reply] |
I know there is a way to achieve the shown data structure because I did it once before with a stock file.
Perhaps How can I visualize my complex data structure? will help you with your data structures; it's what I use to help me with mine.
Unfortunately, I can't figure it out this time and I can't find the code.
Oh, I really do recommend some form or fashion of a Version Control System. I am constantly looking back at things (even very broken things) to find out how I accomplished a particular task, or how not to try to solve a given problem. Recently, I've even begun putting various notes (usually OpenOffice docs) in because, in my case, TortoiseSVN makes it so very easy to keep things in synch between my main work machine and the netbook I carry whenever I leave my home office.
| [reply] |