I want to transform the table in this way so I can have a table where each column represents a product.
After this the goal is to cluster based on different variables, firstly to create the table of Order for every product and then, to be able to change the column and produce the same table (Views for each product).
Is there any way to do this in KNIME and be able to change columns and create this table for different features?
Hi @iperez thank you! The main logic is this. I have this table with 3 variabels Products, Orders, Views but i want to cluster only one variable at a time. Therefore i will cluster all the orders for each product because i want to know that different products can behave similarly.
To get the Orders Output table, I would use row splitters to get three seperate tables based on Product type. Then remove the Product and Views columns using a column filter l. Plus rename the remaining column into either A, B Or C using a Column rename node. Then bring the three newly created columns back together to create one single table, the Concatenate node sbould work.
Can can take a aimilar approach to create the second table (for views).
Might be a more elegant way of approaching this but thats what I would try in the first instance.
