I’m searching for a solution to randomly draw rows from a table that has duplicate entries. The important part here is that the end result needs to be a list with unique entries.
It is comparable to a prize draw situation where you have following situation
These “participants” are in the pot - I want to draw 3 “winner” but each participant can only win one price max. I still want to have the ones with more entries to have a higher chance to be drawn so I can’t just eliminate them with the duplicate row filter.
Does anyone have a solution for this?
this was interesting! I used recursive loop and Random Label Assigner (Data) node to achieve it. Hope I got it right. Here is workflow to check:
Give it a try and in case of any questions feel free to ask.
Thanks! I will check it a bit later on and let you know
I would use simpler approach.
Use Random number assigner with min = 1 and max = number of participants
Sort result by random number assigned.
Use Group by to get rid of duplicates
Filter top 3.
That’s a very good idea! Will check this option as well Thanks!
now that I think of it Shuffle followed by @izaychik63 approach does the trick as well
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.