You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

To add header and trailer in Basic CSV

edited Jul 9, 2024 3:54PM in Account Reconciliation 1 comment

Summary:

Hello, our custom report in ARCS contains more than 1 million records and as per ARCS admin guide CSV formatted is only meant to support 10k records.

Basic CSV format is recommended to use for any high volume but Basic CSV format has no header and trailer functionality.

The report build in our project is being used by downstream applications and Header & Trailer is must for them.

Header - To include report run date and time and Trailer to include the number of records the report extracts.

Any sql query to get the header and trailer added to the Basic CSV format would be highly appreciated!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!