AnsweredAssumed Answered

PI SQL - PIVOT

Question asked by mrai on Mar 16, 2016
Latest reply on Mar 17, 2016 by Roger Palmen

Is there a way to query PI AF using SQL to get the element attributes as columns?

 

Example, the elements have 2 attributes Name, Address. Can we get the below results

 

Element     Name          Address

======     ====          ======

1                 A                 123 W

2                 B                 256 E

Outcomes