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…
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
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.