Hi All
I have flat file of financial data that is on a .csv file.
I have had to group the data by: CompanyID, EmployeeID and JournalAccount using the aggregate function. I am using the sum on Journal Net of Total Adjusted Reclaim Tax and Report Entry Tax Reclaim Trans Adjusted Amount
That is working great but I have a number of other columns I need to output to the export file, but it seems when using an aggregate function, you are limited to just those columns, which means I cannot do a corrected output file.
Initial Import File:
Employee ID
Company
Lakeview Journal
CORP C/CARD
Journal Account Code
Report Name
Journal Net of Total Adjusted Reclaim Tax
Report Entry Tax Reclaim Trans Adjusted Amount
Report Entry Expense Type Name
Report Entry Description
After the aggregate, the only columns I can output are:
EmployeeID
Company
JournalAccount
Journal Net of Total Adjusted Reclaim Tax
Report Entry Tax Reclaim Trans Adjusted Amount