I want to delete duplicate data from PI archives for 150 odd tags.
Is there any tool or method to delete duplicate data?
Limitations: I cannot use PI SQL commander in my environment.
I cannot create new tags since the existing tags are configured in reports using their point ID's.
If you don't fear Excel/VBA and know how to read Excel cells from VBA:
1. Use DataLink Compressed Data to dump all events of one tag (you may iterate over all tags later using VBA) on new worksheet, with timestamps
2. Use Excel formula to compare timestamps in rows (n) and (n+1) and write 1 if they are identical, 0 otherwise
3. Use Excel VBA with PI-SDK to iterate row by row:
- if your flag calculated above is 1 then fetch timestamp from worksheet cell and use PIPoint.Data.RemoveValues as described above (same From and To timestamps and RemoveFirstOnly)
4. End of data mark may be empty cell that is expected to contain a timestamp
You may experience problems during October Daylight Saving Time transition (double hour)