06-22-2017 01:14 PM
Hello,
I have a Keyword Type Group (hsi.keyrecorddata134), in this KTG got 4 keywords ( i.e. Keyword1, Keyword2, Keyword3, Keyword3).
I want to be able to run the report on this KTG pulling Keyword3, I can do something like this below:
select *
from hsi.keyrecorddata134
where Keyword3 in ('ABC')
But the problem I am struggling is, this KTG can be multi-instance, i.e. lets say this KTG got 3 multi-instances, which mean it'll have 3 Keyword3...sometime all three instances (keyword3) will not have the "ABC" value it in. Other time it will have something like Keyword3 = "ABC", Keyword3 = "DEF" and Keyword3 = "ABC"
or Keyword3 = "BLAH", Keyword3 = "DEF" and Keyword3 = "BLA" etc...
So I want to be able to only pull value "ABC" with the result format like this:
Keyword1 | Keyword2 | Keyword3 | Keyword3.2 |
text | text | ABC | ABC |
When I tried the simple query above, it returns what I want but into separate rows. I tried two different select and inner join it still returns with two separate rows.
Thanks in advance for your help.
06-22-2017 01:34 PM
Sounds like you might be able to leverage a pivot function in your query but potentially a long shot.
06-22-2017 01:50 PM
06-22-2017 02:38 PM
06-22-2017 03:10 PM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.