Need to pass parameters to SQL query

iperich

Hi gurus, I need to use as a data source in Alteryx the result of a query that must have a time parameter, as in 'where date_tr>"2017-03-10"', I would need to set as an external parameter the "2017-03-10". The table is way too big to load all the data and filter in Alteryx. 

How can I do that? 

Thanks in advice

bsharbo

There are quite a few ways to do this!  However I first need a little more info.

#1) Is this going to be an application that your end users (or you) run and select the date manually?

#2) Is the date a field that comes from another workflow result?

Do you want an analytic app?

If the answer to #1 is yes, then you can see up an analytic app and provide a list box / drop down option for your users. You would use this to connect to an "update" tool that would update the sql of your input tool box. I have attached an Example of this (you'd have to use your own server + database connection).

If you don't want an analytic app:

If you don't want an analytic app, you will likely want to either use the A) Dynamic Input tool, or #2) A macro.

Another example that I attached named "Dynamic input tool" is a way you can do this with the dynamic input tool (This is how I usually do this if an end user does not 'choose' the date they need)

Dynamic Input Example.yxmd

Analytic App Example.yxwz