I have a list of IDS i.e 4200 as show below
NPI
100398488
100398993
399000499
100389944
.
.
I have a dataset of 1200 records, I want to append the above NPI list and randomly assign values to the dataset as a new column.
RecordID Name NPI
1 A 100398488
2 B 100398488
3 C 399000499
I tried using a RANDINT(45) and created a new column and joined this, but it is too random and not picking enough values. I might be implementing it wrong here. Can you please let me know any alternative logic?
Solved! Go to Solution.
Perhaps fewer random numbers for your Rand to generate?
I'd go up to the number of NPI's you have (in the attached example, I have 4).
But, instead of Rand(4), I use Rand(3)+1. That will also get rid of the zero based values. Of course, you could always start numbering your NPIs with a zero,
Let me know if this helps
Cheers!
Esther