Random % Sample Seed matter

[pzdaniewicz]

Hello all,

I am using on my daily basis Alteryx many times at work.

In one of the process part I need to make a sample from kind reports i.e. 60.

The things I need to clarify are as below:

- when Deterministic Output is marked - does it mean the seed will be kept always the same?

- does the seed changes every time the macro/application will be launched?

- is it possible to include in the output file i.e. second excel tab which will include two variables: sample size and number of seed.

Many thanks for any advises and help

[atcodedog05]

Hi @pzdaniewicz 

Things as per understanding.

The things I need to clarify are as below:

- when Deterministic Output is marked - does it mean the seed will be kept always the same? Yes, check the documentation page for confirmation

 Random % Sample Tool

- does the seed changes every time the macro/application will be launched? Yes, Alteryx makes sure the seed is different every run

- is it possible to include in the output file i.e. second excel tab which will include two variables: sample size and number of seed.? Should be possible to do by creating a cover batch macro. If you provide more info we can provide you more guidance.

Hope this helps : )

[CoG · Accepted solution]

Adding a slight correction to what @atcodedog05 has above:

If you set the "Random Seed" via Deterministic Output, and save the workflow, then it will NOT change when reopened/when macro/application is launched. The seed will remain fixed for all runs.

[atcodedog05]

Hi @CoG 

I actually answered the 2nd question assuming Deterministic Output is not set 😅

But thanks for clarifying it I guess it wasn't clear 😅