I have a Store Procured running against a MS database. The query has a where statement with 10 parameters as shown below. I can able to pass one parameter but when I added the rest of the parameters return no record. I am new to Alteryx and I need help how I can accomplish this? I would like user to be able to filter as their need using those parameters.
Store Procured looks like this:
Workflow that works for only one parameter but adding the second one return no value
Thank you so much for looking to this @atcodedog05
@atcoded the two below screenshot shows the action property.
@atcodedog05 I also noticed and I edited the picture after I saw I missed the replace box for the second action. But here is the screenshot for the second action.
Yes, it run with no error but it doesn't display any record.
Hi @fikeramare
Given the right query your workflow should provide you with output. If there is no data then the issue might be with the starting query itself not with the interface tool 😅