If there are only these 3 columns, it can be quite simple and be done in a Column Expressions node. I put something quickly together for you.
The workflow looks like this:
Input data (same as yours):
Results (same as you want):
Basically, in the Column Expressions, I’m simply checking if each of the 3 values exists in the collection. If exists, return “yes”, else return “no”, and save result in a new column under the name of the relation I am checking:
Great! This is a working solution, but I am not marking it as the “Solution” because if there are unknown or too many values in the collection type column, this solution will not work or will become very repetitive.
Hi @soumyabg , sure, no problem, as I said “If there are only these 3 columns”
If you want something more dynamic, I’d convert to json first, as json structure allows me to have different “columns” if you will, and then convert back to columns. Knime will automatically create the required columns dynamically.
have seen some nice and useful workflows you done lately and wondering why are you not using KNIME Hub to store those? More users will find them and benefit from them, upon modification link still applies and it’s easier for you to locate them and share in another topic…
Hey @ipazin , I guess I’ve not gotten to it yet. In all honesty, I don’t know how to use the Hub to store my workflows
I’m relatively new to all of this. Though I registered to the forum I think November of last year, I’ve only started using it mid-March of this year.
I’ll look into how to store workflows in the hub when I can. Is there any quick guide that I can follow?