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.
Yes! This is very possible by converting your workflow into an Analytic App. I've attached a sample workflow which should help you get started, but I'll explain the logic below.
You want to add your input tools to collect user input, and connect them to your Input Data Tool, with the Update Value with Formula configuration selection.
I've found that the best way to do this is by setting your SQL Query to have:
SELECT * FROM TABLE
etc... for as many conditions as you expect to have.
When you do this, you can then use the following formula in your update tool:
IF !IsEmpty([#1]) THEN Replace([Destination],'1=1',"[Field1] = " + "'" + [#1] + "'") ELSE [Destination] ENDIF
This means that the 1=1 will remain if no input is selected for that field, otherwise it will be replaced with the condition you desire.
For dates, I generally just set the generic SQL query to [Date] >= '2010-01-01', and then use the "Update Value" configuration in my Update tool with the "Replace a Specific String' checked off, and 2010-01-01 in the box below (note the lack of quotes in my previous 2010-01-01, this is important, at least for SQL server, for the SQL query to be parsed properly).
Let me know if you need clarification, or have any more questions about this,