topic Re: Pass a value to a Random Sample Tool in Alteryx Designer Desktop Discussions

Pass a value to a Random Sample Tool

WCPete — Thu, 24 May 2018 04:45:46 GMT

I am trying to pass a value I calculate in one section of a workflow to a 'Random Sample Tool' so I do not have to manually type the value in. I used a text input tool for the attached example, but, the text input will be replaced with an actual file in the future.

I would appreciate any help.

Thanks You

Re: Pass a value to a Random Sample Tool

MSalvage — Mon, 22 Jan 2018 17:44:54 GMT

Hi @WCPete,

I would recommend using a batch macro for this process. The number you have calculated will go into the control parameter then you will use an action tool to update the value in the random sample tool with this value.

It should look something like this.

Hope this helps,

MSalvage

Re: Pass a value to a Random Sample Tool

WCPete — Mon, 22 Jan 2018 19:16:57 GMT

Thanks @MSalvage - but - I am not sure how to configure the tools. I tried this, but, I get an error "Control Parameter must be mapped to a field".

I will keep looking :).

Re: Pass a value to a Random Sample Tool

MSalvage — Mon, 22 Jan 2018 19:22:44 GMT

@WCPete,

Make Sure you click on the Questions tab and select which field contains the Update Value.

Best,

MSalvage

Re: Pass a value to a Random Sample Tool

WCPete — Mon, 22 Jan 2018 19:33:19 GMT

Thanks again @Msalvage, but, I have never used a batch macro or had to in the past so I am still struggling.

Re: Pass a value to a Random Sample Tool

MSalvage — Mon, 22 Jan 2018 19:54:47 GMT

@WCPete,

Attached is a working example, might need some slight tweaking, but hopefully it will get you going.

Best,

MSalvage

Re: Pass a value to a Random Sample Tool

WCPete — Mon, 22 Jan 2018 20:41:27 GMT

Thanks @MSalvage! I am sure that took longer than you anticipated.

I have included the final workflow.

I am leaving these questions out there in the event someone can point me to a good example demonstration on these.

1. I am not sure the reason to update this Text Input other than to accept the field I am passing in the workflow?

I am not sure why I needed to update the second drop down or how it affects my workflow?

Thanks again @MSalvage!