How to Pass the Date Parameter at runtime to Workflow which is connected with database

Question

Hi All,

Need your help here !!

My workflow is connected with Database - Complex SQL & Large Dataset.

Here is the details of my workflow -

1. My workflow is connected using DB2 Database. My base tables contains very large numbers of records for more than a year period.

2. My SQL queries are designed using "From Date and To Date " parameters.

3. I want to develop this workflow which should take user input at runtime two parameters i.e.  From Date and To Date

4. Based on provided input query will execute and fetch the records for given period.

Regards

Atul Deshpande

alexnajm · Accepted Answer

Analytic Apps are what you are looking for! The Date tool can go in and update your query to the start/end dates that the user selects. Analytic Apps (alteryx.com), Interactive Lessons - Alteryx Community, and Solved: Analytic App to Create Custom SQL Query - Alteryx Community are all helpful resources to get started!