Text/CSV Export: Add Trailer Record

Hey there, 
I will be intrigued if others have an option for this.
Here is another post on community that confirms my suspicion, the export can’t include the sum of records as an additional “trailing” record 
How to include the Aggregate Field like Sum in GI Export to Excel? | Community 

As a workaround for the time being however, perhaps try exporting to excel, then have excel do the summation of records, then convert excel to CSV when saving. 

It’s not an all in one workaround, but it would get the job done in the meantime while waiting for others to confirm if possible to have an export sum those records itself. 
 

​@MissyMain41, thank you for the input! Unfortunately, I don’t think that will work even temporarily in this scenario. We are setting up an API with the bank so that they can pick up this file. It is a GI that is filtering into an export scenario to create a comma-delimited text file. That file would then be picked up by the bank in an automation schedule. 

I was able to map everything out in the export scenario to the file except the trailing record. I can’t figure out how to map in a final line (if at all possible). 

Hi ​@rjarrell81,

I do not think there is any OOB solution to include the footer line in GI or export scenario. Maybe you can create a custom Data Provider to add that trailing record and use that to export.

We also just had a request for the exact same thing and the only solution we could come up with was to create a SQL view that adds the trailer record. In our case they wanted the last row of the CSV to include the word ‘END’ and the total count of all the rows. We then used the sql view as the source of the data for the GI that feeds the export scenario. Below is an example of what the export scenario looks like and the resulting CSV file: