I have data from one table going to another. there are 7 columns in both tables.i want to aggregate the balance field based on 2 fields but for all 7 columns to be filled with data in the second table as well. im using an aggregate box but when i tick the fields i want to aggerate on the dont come through to the second table.
OK so say you have one fund code and one account code but two account names. If you sum the balance, grouping by fund code and account code, which account name gets the balance in the resulting row set, or do both account names get the balance?
FWIW, I often find complicated aggregation is easier to do in SQL (e.g. in your OLE DB Source ) than in the aggregation component, which is best suited to simple things.
thats a good point actually they never said with names get it. i will have to ask them.
ya i was think an sql script might be the best way to go about this. just wanted to know if you could pull through the names even if you dont tick them in the aggregate box