With this table: [image] I need to distribute the values, 0, 1, 2, 3 randoomly between those 250 rows filling ‘x’ column acording the proportionality en each column. So, literaly I need to fill column ‘x’ with 125 registers with 0 value, 25 registers with value 1, 75 registers with value 2 and 25 registers filled with value 3. How can I accomplish this? Thanks in advance.

Hi @jpages , here is a wf that could help: [image] How to distribute according to proportionality – lelloba Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Basically, what I do is 1) mizxing rows and then 2) assign 125 labels “1”, 25 labels “2”, etc. You can even use variables if you want (I haven’t). If you are not interested in assigning exactly 125 rows to label “1”, you can make it even simpler and use a random label assigner (probability-based). Have a nice evening, Raffaello Barri

How to distribute according to proportionality

KNIME Analytics Platform

jpages March 8, 2024, 1:40pm 9

I alreaady solved with the help of this post:

Thanks for all.

2 Likes