AnsweredAssumed Answered

PI rdbms interface -In a row have many time stamp  and values

Question asked by CSCT64 on Nov 23, 2016
Latest reply on Nov 28, 2016 by gachen

Hello,

 

I'm trying to collect predict  data form sql server by using rdbms interface.

 

My sql table likes this :

in every row have 4 values, 

the time stamp of value1 is 2016-11-23 16:15(timestamp + 15m)

the time stamp of value2 is 2016-11-23 16:30(timestamp + 30m)

the time stamp of value3 is 2016-11-23 16:45(timestamp + 45m)

the time stamp of value4 is 2016-11-23 17:00(timestamp + 60m)

 

But I don't know how to configure it .

Thanks,

Outcomes