Forum Discussion
Solved
Print values from a row based on a condition
Hi all,
I'm looking to create a column in a table "Source" that display only specific values from a row that matches the condition. The table row for Column ID meets more than one condition. For example: I have a table called "Source" that contains column ID and another table "Category"
Source #
| ID |
| gpl 3.0, mpl 1.0 |
| gpl 2.0, gpl 3.0 |
| mpl 1.0, gpl 2.0 |
| apache 2.0, mpl 1.1 |
| apache 2.0, gpl 3.0, gpl 2.0 |
Category:
| ID | Category |
| gpl 2.0 | Graylist |
| gpl 3.0 | Blacklist |
| mpl 1.0 | Graylist |
| mpl 1.1 | Blacklist |
| Apache 2.0 | Whitelist |
Is there a way to filter values based on a category and display only the values specific to a category, even though the row contains values from all 3 categories.
