I created an automation that loops through my query by date, incrementally. If I use excel, i am able to append the result from each loop to the same excel spreadsheet. Yea!
However, my data set is growing, and I now generate more than 1M records... so i would like to move my output to a CSV file. The first loop to the CVS file works great, but the subsequent loops fail because the file already exists. Is it possible to append the output stream so that all the data ends up in one CSV, like a can in excel? I can't see an "append" option, like i see with excel... am i missing something?
Thanks for any help!