lchaylian

Writing RDBMS data to PI when all the fields are in one column

Discussion created by lchaylian on May 13, 2009
Latest reply on Jun 26, 2009 by cescamilla

Hello,

 

Notmally when you read SQL data using RDBMS interface to PI you get one value by one column, it means one column by tag, for instance:

Select A,B,C where fecha=#12-05-09#
Where TagA = A, TagB=B and TagC=C

Our need is to read in this way:

Select values where fecha=#12-05-09#
Where values = "A,B,C"

So we have all the values in one field like comma separate string

 

How can we read these ?

 

Kind Regards

Outcomes