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.