1 column with 1200 rows

[domiterd]

So I have 1 column name: Value and it has 1200 rows. I need to transform it to 100 column with 12 rows in each coloumn. Help

[rfeigel]

Have you tried a Group Loop?

[HansS]

Hi @domiterd

Do a Chunk Loop Start node (12 rows per chunk) and collect your results with a Loop End (Collumn Append) node.

gr. Hans

[rfeigel]

@domiterd Try this. It avoids missing values in the Loop End (Column Append) node.

[Daniel_Weikert]

Column to Grid node (but be aware of how the grid is build) Otherwise see proposals
br

[knimediger]

@domiterd
First of all: Welcome to the world of KNIME.

@domiterd

So I have 1 column name: Value and it has 1200 rows. I need to transform it to 100 column with 12 rows in each coloumn.

That requirement does not consider any relation of the 1200 rows of data to their place in the 12x100 target matrix. Is this really without any relation? Or do you have any further information in each row which will define the place in the target matrix (12 cols could 12 months)?

Maybe you can give some more information? Would it be possible to further show some sample input data and the requested output?

[rfeigel]

The Column to Grid node places data in rows rather than columns. I’m not sure that’s correct.

Origianl Data

[Daniel_Weikert]

That’s what i meant with (be aware of how the grid is build). I do not know the exact use case here
br

[rfeigel]

I agree; its not clear what the desired result is although @domiterd apparently marked your suggestion as “solved.” It would be nice if they would clarify.