Trying to take input from user to use it as parameter in my query

mertmetinn

Hi everyone,

I am trying to use an analytic app in Alteryx to take input value from the user to use in the query as an input.

For eg:

SELECT * FROM dbo.Mega

WHERE CAMPAIGN LIKE "%x%"

I want to take this x value from the user and then use it in the query instead of x.

How can I do that? any video, sources, articles? 

Regards, 

DataNath

Hey @mertmetinn, I'd do this with a Text Box interface tool and Action tool linked to your Input Data tool. Here's a quick example:

1) Set an initial template query. In your case this is:

SELECT * FROM dbo.Mega

WHERE CAMPAIGN LIKE "%x%"

In my example:

2) Link a Text Box tool to your Input Data tool - an Action tool will appear automatically between. In the configuration, find the 'Query - ' line under FormatSpecificOptions and click on this. Tick the 'Replace a specific string' box below and reduce this so it's only the text you want to replace - in your scenario, 'x'. In mine, this is 'Day 10'.

Note: I'd recommend using something a lot more explicit than 'x' here - as you're replacing the string with the user's input, this will replace any instance of that. Therefore, if you have any other 'x' characters in your query, they'll get replaced with the user-provided value. I normally use a very specific placeholder like <DummyValue> and use that as the replacement target.

3) When I run the workflow as an app and enter something different i.e. 'Day 15' in this case, this replaces the template value in my query and returns Day 15 values as you can see in the Browse output window:

Hope this helps! Feel free to shout if you need any additional help.