Covert a comma string into separate rows

[Former Member]

Hi,

I have a scenario where I have to convert the below into separate distinct list -

I need to convert into the below format

NPE-University

NPE-Inventor

NPE-Company

NPE-Patent Aggregator

Op Co-Competitor

Op Co-Licensing

NPE-Co/Inv

OpCo-G2k

OpCo-Other

There could be two scenarios for that -

1. This can be modified using the custom LOV (as I need the distinct separate values to display in the prompt for user)

2. This can also be changed into a new column that displays distinct separate values

Your help is really appreciated!! Thanks!

[Former Member]

create a derived table with the values you want in another column. this way you can use this as any other attribute for the table