Writing to CSV

tellieno,

You are correct. It is best to store up the data for a given line in your CSV and then write it to a file in one shot. To do so, you have a few options.

• If you're using either the Professional or Enterprise Edition you can check the box under the Advanced tab of your extractor pattern that says, "Automatically save the data set generated by this extractor pattern in a session variable". This will store all extracted data as a session variable that is a dataSet object.
• Alternatively, store each piece of data as individual session variables.

Once all data for the current iteration is saved in session and you're ready to write it out to a file then you will first need to add the data to a dataRecord object that the CsvWriter then uses to write to a file.

If you chose to store your extracted data as dataSets then you'll be working with three session variables: Two dataSet objects and one variable.

Here is example code for Iterating over DataSets & DataRecords. When creating a new dataSet object to store your soon-to-be-written dataRecord object just use the two dataSets you already have in stored as session variables.

Otherwise, if you stored each variable individually, just add them one-by-one to your dataRecord.

Once everything is in one dataSet with one dataRecord then have the CsvWriter Write the dataRecord to the file.

-Scott