Have the Column Headers show up regardless whether this is the first of second file of an export data file?
Have the PI Integrator for Business Analytics always create Column Headers regardless if it appending to the same file or a different file, and ID to reset to 1. Currently, "Append Timestamp" is unchecked and upon the program removing the file from the original export location, sometimes the column headers will not show up and the ID will not reset as the Integrator believes that it is appending data when the first file that is gone. The First file will always contain the Column Headers and ID will start at 1. Please let all subsequent file Column Headers and ID will start at 1.
Peter Liu commented
AdminJoy Wang (Product Manager, OSIsoft) commented
Thanks for the feedback! Are you using the File target or the ADLS gen 1 target?