Create a random list of values

Hi,

i need a random list of values.
e. g.

table 1: (all customer numbers)
customer nr.
1
2
3
4
5
6
7

And i want to create a random list e. g. 3 value from the table selected by luck
Result table
Customer nr.
3
5
7

Which notes i can use?
In the real case i need 130.000 values from 2.5 Million values (and it should select values evenly spread-> some from the beginning, middle and end of the table)

Hope someone could help me. Thanks. Regards Chris

The Row Sampling node does what you want:

There is also Bootstrap Sampling and Equal Size Sampling in the same category in the node repository which might help

Steve

3 Likes

Hi @s.roughley thanks a lot for your help. This was exactly what i need. Regards Chris

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.