🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Inserting a unique header row into an already parsed data in DPS to be exported for SQL as CSV

User: "Henry_21370"
Henry_21370
Altair Community Member
Updated by Henry_21370

Hello,

 

I would like to know the best approach as to how I may insert a header and trailer into parsed data to be imported into SQL.

 

I need to add the following items in the header (to be exported as a pipe-delimited in CSV file):

    1) the captured file name of the input file (metadata information?)

    2) the total number of rows of parsed data

    3) the total amount in $ from a summed column

 

I currently have 12 columns of parsed data, so I understand that the header will not be aligned with the data columns.

 

The trailer should just contain an 'End of File' row for SQL to recognize that no further rows of data is in the pipe-delimited CSV file.

 

I checked out the following previous discussion thread for a similar procedure, but had no headway into how to make it work properly, unless it can truly be accomplished through Monarch Classic application using the Summary tab. Not sure how....

 

 

https://community.datawatch.com/thread/3695

 

 

Thank you for your feedback.

 

Henry

Find more posts tagged with

English
Monarch
Quick Links