Feature Vector Generation

Hi folks,
I am new in KNIME so I would need your valuable support :slight_smile:
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

Hi,

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

Screenshot 2021-04-25 162632

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).

Screenshot 2021-04-25 162257

This gives the following result:

Feature vector.knwf (10.9 KB)

Cheers/Evert

4 Likes

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

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.