Forum Discussion
Assign Random Number For Each Distinct Item
Hello, I have a table with document numbers and $ amounts. Some document numbers have multiple amounts, so those numbers repeat within the table. I'd like to assign random numbers to each disti...
I think my solution is to pull in the document numbers into a separate table, remove duplicates, assign random numbers, and then create a relationship between the distinct table and the table with duplicates. Still open to other ideas if someone has a better solution.
I think my solution is to pull in the document numbers into a separate table, remove duplicates, assign random numbers, and then create a relationship between the distinct table and the table with duplicates. Still open to other ideas if someone has a better solution.