# Repeating column values 10 times

thank you ! i made it.
I’ve got another question, if it peossible is , to repeat each number 10 times, i mean in a specific column with 20 number , each number would be repeated 10 times in the same column, this pathern;
1 1
2 1
3 1
4 1
. 2
. 2

Hi there @joan,

moved your question to a separate topic as it wasn’t really related.

Regarding your task you can accomplish it in a following way using Counting loop. If order is not important you can remove Counter Generation and Sorter nodes.

Here is link to workflow on KNIME Hub to check it out.

Br,
Ivan

4 Likes

@ipazin
thank you, that was really helpful but unfortunately the table that I’m working on that, is somehow that sorter can not be the case , because the table contains 4 columns that despite of first one , rest are not sorted

Hi there @joan,

not sure I understand what is troubling you. Adding counter is actually not for sorting but for preserving row order. Meaning to have same order of rows in your output table as at beginning.

Input Table:

RValue – AnotherValue
Value1 — ABC
Value2 — DEF
Value3 — GHI

Output Table:

RValue – AnotherValue
Value1 — ABC
Value1 — ABC
Value1 — ABC

Value1 — ABC
Value2 — DEF
Value2 — DEF

Value2 — DEF
Value3 — GHI

Value3 — GHI

Hope this helps.

Br,
Ivan

@ipazin unfortunately this repeats the valuses in series, i mean
ABC
DEF
GHI
ABC
DEF
GHI
Attatched is the table that i wanna work on , maybe by taking a look at it you would figue out, what my problem is…

profile.txt (30.5 KB)

Hi @joan,

so you want to repeat values from one column and what should be the values of other columns? Empty? Missing? Can you try explaining how your output should look like at the end?

Br,
Ivan

the table contains 5 columns, 2204 rows , each row should be repeated 10times ,
row0 3 100 0 130 1
repeated (row0) 3 100 0 130 1
.
.
.
row1
repeated(row1)
.
.
.

Hi @joan,

if I’m not mistaken that is exactly what my workflows does

Add another column to Table Creator node and check it out.

Br,
Ivan

@ipazin
yeeeeaaaah! thanks Ivan, I did forget to base it on counter, now its works!

BR!
Joan

1 Like

Hi @joan,