Hi all, hope you’re doing well,
I recently started with Knime and I’m trying to come up with a way to create rows based on columns.
I have a few columns to the left that have the characteristics of say an individual, and a set of columns (weeks) to the right identifying the value of each individual in each week. I want to rearrange the data so that I’ll have only one column with the name “Period” that has the week ID in each row, and a second column that has the value of each week. It is basically as if I where to, in Excel, transpose the data of the “week columns”, but repeating it for each individual. Table 1 would be my table before, and Table 2 my table after.
I actually created a VBA macro that does this, but it has its limitations in terms of data size and I think Knime could be of great help.
Anyone knows how I could approach this?
Kind regards!
