Saving data to same csv record from two different scrapeable Files

Hi

I seem to be struggling of late. I am trying to scrape a not very well put together site.

I would like to save the 'PRODUCTID' from the search results scrape into the same row of my csv file that I am writing to in my dataset from the product page.

I hope that this makes sense - I am using the csv writer as below (the first two in the header are from the search results). If I do this and call the writer after both the search results scrapable file and the product page scrapeable file i get a record on each line. I am using the Professional version (although I am clearly not a professional)

Thanks for your help in advance

Jason

// Create CsvWriter with timestamp
CsvWriter writer = new CsvWriter("GlenDataIn.csv");

// Create Headers Array
String[] header = {"PRODUCTID", "PRODUCTNAME", "DESCRIPTION", "PIC1", "PIC2", "PIC3", "PIC4", "PIC5", "PIC6", "PIC7", "PIC8", "PIC9", "ID", "MAKE", "MODEL", "YEAR", "SEARCH", "PRICE", "ID"};

// Set Headers
writer.setHeader(header);

// Save in session variable for general access
session.setVariable( "WRITER", writer);