I have a requirement to transfer PI data to external Vendor through a CSV file. The CSV file has a specific format where first two Columns are reserved for Vendor and from the next Column onward (First row) it should contain PI Tags and Second row should contain Snapshot values. The CSV file should be scheduled to update every 5 hours so that the most recent Snapshot data can be sent to the Vendor. What should be the most efficient way to incorporate such requirement, specially creating such customize CSV file which updates on a regular interval.
Thanks in advance for your help.