Random % Sample Seed matter

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

Screenshot.PNG

Workflow

Accepted answers

CoG

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.

All comments

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

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 😅

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335