Hello everyone!
I am new to this software and am looking for some help in solving a seemingly simple problem that I am however stuck on.
As in the example reposted below I have a list of brands (column 1) and a list of products (column 2) in which the brand is also inside. What I would like to do is to be able to split these two pieces of information, identifying which brand is inside column 2 and then create two new ones one with just the brand and one with just the product.
Hi @HansS Thank you very much, you have brought me very close to the goal!
One thing I didn’t specify is the assumption that the band column (Column 1) is incomplete and you don’t know any names/rows.
In this case in the ouput result in the “product column” there should be all the product name and brand, instead in the result of the “brand column” there should be a constant that makes this situation clear (like a string “not know”).
It is a little bit confusing to me.
Is it correct that you have only 1 input column (Input Brand + Product) ?
Or is there also a column Input Brand? And what is the content?
Ok that’s clear. And tnx for the sample data you provided.It makes working on a solution much more convenient. I added a Joiner and a Rule Engine node to the flow. KNIME_project_22-new.knwf (68.5 KB)