Skip to Content
0
Former Member
Jan 15, 2012 at 08:59 PM

flat file compression / summation

34 Views

Hi: In my export transaction data file I have converted Master Data such that

Company A = Company C

Company B = Company C

Rather that seeing

Company C, 1000

I am seeing

Company C, 500

Company C, 500

How do I compress and sum the data in the flat file so that I only see one row? The same issue is also occuring for accounts that have been converted, and it is exponentially growing the volume of data.