This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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)
Another question: I'm obtaining the records I need quite well, but I'm having another task: I need to delete records that are before or after certain given date. So, I have the same problem but not as an input, but an output. I need to execute a "delete * from table where date > xxxx" where xxxx is a parameter, an do this BEFORE inserting all the data.