Help to retrieve data from PI OLEDB database

Discussion created by rchandler on Oct 22, 2012
Latest reply on Oct 23, 2012 by spilon

I am new to PI development. Currently I am developing a query  to return data.


I find that in snapshot , I can query data out, something like this: 




elemnt        attribute           time                        value


3SS 90%   Comment        ****                     ****
3SS 90%   DateTime        ****                     ****
3SS 90%   Description     ****                     ****
3SS 90%   Group              ****                     ****




I want to convert this this format in PI OLEDB commander:


element     time    Comment     DateTime   Description   Group


3SS 90%  ****       ****                  ****              ****                      ****


Does PI OLEDB have some specail way to turn   this table around?


Any suggestions will help me a lot. Thanks in advance!