bswnaosn

Transposing Results

Discussion created by bswnaosn on Apr 11, 2014
Latest reply on Apr 17, 2014 by bswnaosn

For my current project, I am looking to pull the snapshot values for a number of tags. Ideally I would like to have the typical results for the query transposed, so that the tags become columns. Is there no support for a query (OLEDB Provider) such as this?

 

Example:

 

SELECT tag, value
FROM [piarchive].[pisnapshot]
WHERE tag IN ( 'sinusoid', 'sinusoidu' )

 

    tag                  value

 

1 SINUSOID    123.456

 

2 SINUSOIDU 456.789

 

When I'm looking for:

 

   SINUSOID  SINUSOIDU  

 

1 123.456      456.789

Outcomes