AnsweredAssumed Answered

How to transpose rows to columns PI server

Question asked by Raghu.Kasukurthi1 on Feb 6, 2018
Latest reply on Feb 7, 2018 by vkaufmann

Hi All,


I just started exploring PI Historian and right now I am accessing PI Data Using JDBC Drive which gives data in this format for below query


SELECT Tag,"value","time",status FROM PICOMP pc Where

pc.time > TIMESTAMPADD(SQL_TSI_MINUTE, -1, now())

and pc.value > 10

Well1.TubingPressure39.56892018-02-06 20:07:18.00
Well2.TubingPressure49.192212018-02-06 20:07:18.00
Well2.CasingPressure9.192212018-02-06 20:07:18.00


In PI do we have any tools which exposes above data as shown below when accessed through JDBC Driver ?


Example query :Select Well,TubingPressure,CasingPressure,Timestamp from WellPropertiesTable

Well139.5689NULL2018-02-06 20:07:18.0
Well249.192219.192212018-02-06 20:07:18.0