Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

"force" rand() to produce designated number of matching values within range

jeanilieski
8 - Asteroid

Dear all,

 

I tried to find answer on the topic but did not come even close to it, so I kindly ask for help. I have attached a file with a sampe of my data to be easier to explain.  As you can see, the column "in hour" takes the value from the column "hour" each time the randomly produced number from the "rand" column falls within the range of "min" and "max" columns (which are fixed values).

What I try to achieve is to "force" the "rand" column to yield exactly as many values that will fall within the range of "min" and "max" as the value in the "prob Anm" column. For instance the "webinar_id" 645 has two entries that fall within the range, but "webinar_id" 643 should have 1 match, but has none, or "webinar_id" 644 has 1 match but should have 2.

Please note that when in "prob Anm" stays 0, no random number from "rand" should fall in within the range of "min" and "max".

Thank you for your answer!

 

4 REPLIES 4
mmenth
11 - Bolide

Hi @jeanilieski,

 

In order to "force" the number of instance that fall in range, could you to randomize twice? For instance, for webinar_id =643, prob Anm = 1, you could randomly pick one of those rows, then randomly pick a number between that min and max. For the others, you can randomly pick a number outside that min and max. Make sense?

 

Best,

mmenth 

 

Thableaus
17 - Castor
17 - Castor

Hi @jeanilieski 

 

I could have done with 1 batch macro, but I decided to go with 2 iterative macros. It took me a while to get the right mindset.

 

Please check the workflow and macros and let me know if you have any doubts. I also changed the Input to a .yxdb to be faster.

 

Package appended.


Cheers,

jeanilieski
8 - Asteroid

thank you mmenth.

your thought gave an unexpected twist in my workflow, but for now it works. In case I cannot go until the end, i will come back to you, and in case it works I will soon accept your solution officially

jeanilieski
8 - Asteroid

thank you Tabelaus, I will have a look, although I try to follow the answer of mmnth now.

Labels