How to create links with multiple values in a column?

[Deleted User]

SonPat99 wrote:Does your source really store "a, b, c" , "f, g", "10; 20", "40; 50; 10" as values?No, this is a UI and the UI is showing multiple values for a specific field; which again stores the data in column format (and not row-wise).We are using PIVOT to convert the data in ROW Wise format and in the same process, using LISTAGG to club all the values for a column (like Department).

So your source DOES store the distinct values and you transform the data into the form you show in the image. You HAVE the raw data.

The answer to Gianni's question is "Yes", and not "No". The problem you face is custom-made by yourself.

Gianni Ceresa

If instead of concatenating 'a, b, c' you concatenate '<a href="...">a</a>, <a href="...">b</a>, <a href="...">c</a>' you still get a string as value.

The difference is that this string is an HTML string and you can kindly ask OBIEE to shows it as HTML instead of just a string. The HTML contained in your string will turn the 3 values into links.

SonPat99

Hello Gianni,

Please allow me sometime to check on this, maybe a day or so.

Will update with my findings.

[Deleted User]

You understand what we're saying here, correct?

a) Either show everything row-wise and use vanilla functionality (links) or

b) first href everything and then do all the LISTAGG/PIVOT that you need to put the values into columns

SonPat99

Yes, I have understood the details. Thanks for checking again.