MikeRoberts Member

Thanks @jaeW_at_Onyx.

Thanks @GrantSmith. I get that Beast mode runs per a row... but odd that the running of the rand() function would return the same result every time it's used on the same row? That's not quite the point of a rand()? Anyways, doing it another way so no biggie. All good learnings for me. Thanks!

Thanks for this @GrantSmith. A neat solution :-) Some slightly strange behavior though... Here's the formulas used in Beast mode... and here they are when put into an ETL. Suggests that in Beast Mode the the rand() function is runfor the row rather than for the row and function. But I've got the result I need, so all good.…