4 of 4 people found this helpful
If I understand you correctly, you're trying to get multiple strings returned from the table? If that's the case, you can use the String Array data type.
In PI System Explorer, create your table. Here's an example table I'll use for right now:
Then, go to the attribute you're trying to configure, and select Value Type > Array Types > String.
Then on the Data Reference > Table Lookup. Click Settings to build your query. Make sure to select the "select array of value matching criteria" option for "rule".
Then you should have as many strings as the query returns held in the form of a string array.
If this isn't what you're looking for or can't get it to work, I'd be happy to help on a remote session with you.
I couldn't find how to work with the "IN" operator, I thought I tried everything but it seems I didn't try the most obvious one!
Thanks a lot Kelsey Duffy, as always, this forums find a solution in a smooth and fast way.
I'm glad it's working for you! And thanks for the vote of confidence for PI Square.