wangqi

Table transpose

Discussion created by wangqi on Oct 21, 2013
Latest reply on Oct 22, 2013 by hanyong

hello!

 

how can I get a table like this from PI dababase by SQL?

Time

Sinusoid

Sinusoidu

2013-10-21 09:28:18

1.61433

83.48389

2013-10-21 09:38:18

2.941835

86.06758

The table I get  as shown below

Time

Tag

Value

2013-10-21 09:28:18

Sinusoid

1.61433

2013-10-21 09:38:18

Sinusoid

2.941835

2013-10-21 09:28:18

Sinusoidu

83.48389

2013-10-21 09:38:18

Sinusoidu

86.06758

Outcomes