Feature Vector Generation

[Matthew313]

Hi folks,
I am new in KNIME so I would need your valuable support
I want to generate a Feature Vector as shown in the below example

I have 35 products therefore I want to create a feature vector for every product. How can be done this with KNIME nodes?

Thank you in advance,
Matthew

[evert.homan_scilifelab.se]

Hi,

Provided that you can add the Product as a separate column it is relatively straightforward. Here is the input I used:

First use GroupBy node to group on Product, and aggregate Var columns by concatenation. Then split each aggregated Var column into separate columns using the Cell Splitter node 3 times (it can only handle 1 column at a time).

This gives the following result:

Feature vector.knwf (10.9 KB)

Cheers/Evert

[Matthew313]

@evert.homan_scilifelab.se thank you so much for your time Cheers from Sweden