Convert one single row of n(=pxq) columns into p rows of q columns

Hi,

I didn't found this subject on the forum. Here is my problem: The REST Api node collected data which representation is given into one single row repeating the same pattern. Example:

Data.itemA1, Data.itemB1, Data.itemC1, Data.itemA2, Data.itemB2, Data.itemC2, ...

I need to have it represented in one table this way:

Data.itemA1, Data.itemB1, Data.itemC1,
Data.itemA2, Data.itemB2, Data.itemC2,
...

This means dividing (in this example) a table of 6 columns into a table of 2 rows of 3 columns each.

I tried to use the row partitioning which can extract the first row of 3 columns, but I don't know how to recursively appy this partioning to the remaining rows.

In R, this could be done this way:

> tabA <- c("Data.itemA1", "Data.itemB1", "Data.itemC1", "Data.itemA2", "Data.itemB2", "Data.itemC2")
> dim (tabA) <- c(2,3)

How could we make this with KNIME ?

Best regards

Hi Euler,

I think the workflow in attachment is what you seek.

Best regards

Fabien

Thank you Fabien,

This was exactly what I was looking for.

Best regards

Thank you Fabien,

This was exactly what I was looking for.

Best regards