Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
I was wondering if location should not be >0 rather than >1 ?
The findstring function is 0 based, so if your field was "Jan oaeuoeu.a" and looked for Jan, the findstring function would return 0. If it doesn't find it, it returns -1. So I usually define it as >-1.
The first method, on the left, does not have to be actually connected to the parameter control? However, if I isolate it from the rest of the macro and use it separately, then it doesn't work in my flow as it does not show the tab "questions" at all and there is no output.
Not having to connect interface tools has been game changing for me. As for trying to isolate it and use it elsewhere, there are a couple points: 1) I created a batch macro as you can see on the workflow configuration tab of the macro. Control Paramaters will only work in batch macros. 2) If you did try to copy the control paramater to another batch macro, you will have to rename it on the workflow configuration tab. You can see on the configuration tab that I named it match:
If I copy it to a new batch macro, it get's renamed:
To rename it, you can click on the tool, then the annotations tab, then rename it from Control Parameter (2) to Match:
That should do the trick.
How would you isolate the 3 methods, particularly, I am curious to understand how would the first one work (on the left).
You would need the macro in and the control parameter for all 3 methods. I've added a comment box to the picture below to show you which pieces are needed for which:
For testing/debugging purposes, methods 1 and 2 allow you to try out different values by putting sample data in the workflow configuration tab and clicking the play button with the macro open. In the first picture above, you can see that I'm testing the value "Jan". The macro will work without a test value, but you can use test values during testing/debugging. Test values will not affect the value when the macro is actually used in a workflow.
Also, what do these values in the formula actually do: [#1], '%Question.ControlParam.Match%'.
the [#1] is using the data in the formula tool from a connected interface tool. Note that I connected the control parameter directly to the Q of the formula tool. check here and here. Essentially, the data from the connected tool name #1 (Alteryx's default name) is passed directly from the control parameter into the formula tool.
the %Question.ControlParam.Match% is using the data in the formula tool from the interface tool named Match. This can be used almost anywhere, and without actually connecting to the tool. I believe it's called a "reference shortcut". I love the warning in the help documents: "Be cautious when using this method, as it may not always produce expected results." I use this method all the time except in the rare case where I have to use an action tool. Note that you sometimes have to put it inside quotes when using it just like I did in this example.
Amazing! You are a superstar! :)
@patrick_digan wrote:I was wondering if location should not be >0 rather than >1 ?
The findstring function is 0 based, so if your field was "Jan oaeuoeu.a" and looked for Jan, the findstring function would return 0. If it doesn't find it, it returns -1. So I usually define it as >-1.
The first method, on the left, does not have to be actually connected to the parameter control? However, if I isolate it from the rest of the macro and use it separately, then it doesn't work in my flow as it does not show the tab "questions" at all and there is no output.
Not having to connect interface tools has been game changing for me. As for trying to isolate it and use it elsewhere, there are a couple points: 1) I created a batch macro as you can see on the workflow configuration tab of the macro. Control Paramaters will only work in batch macros. 2) If you did try to copy the control paramater to another batch macro, you will have to rename it on the workflow configuration tab. You can see on the configuration tab that I named it match:
If I copy it to a new batch macro, it get's renamed:
To rename it, you can click on the tool, then the annotations tab, then rename it from Control Parameter (2) to Match:
That should do the trick.
How would you isolate the 3 methods, particularly, I am curious to understand how would the first one work (on the left).
You would need the macro in and the control parameter for all 3 methods. I've added a comment box to the picture below to show you which pieces are needed for which:
For testing/debugging purposes, methods 1 and 2 allow you to try out different values by putting sample data in the workflow configuration tab and clicking the play button with the macro open. In the first picture above, you can see that I'm testing the value "Jan". The macro will work without a test value, but you can use test values during testing/debugging. Test values will not affect the value when the macro is actually used in a workflow.
Also, what do these values in the formula actually do: [#1], '%Question.ControlParam.Match%'.
the [#1] is using the data in the formula tool from a connected interface tool. Note that I connected the control parameter directly to the Q of the formula tool. check here and here. Essentially, the data from the connected tool name #1 (Alteryx's default name) is passed directly from the control parameter into the formula tool.
the %Question.ControlParam.Match% is using the data in the formula tool from the interface tool named Match. This can be used almost anywhere, and without actually connecting to the tool. I believe it's called a "reference shortcut". I love the warning in the help documents: "Be cautious when using this method, as it may not always produce expected results." I use this method all the time except in the rare case where I have to use an action tool. Note that you sometimes have to put it inside quotes when using it just like I did in this example.
