Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to pass multiple dynamic parameters to the expression of a filter?

fikeramare
6 - Meteoroid

 

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:

fikeramare_0-1635302436927.png

Workflow that works for only one parameter but adding the second one return no value 

 

fikeramare_2-1635302703581.png

 

 

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @fikeramare 

 

Can you share snapshots of your action tool configurations.

fikeramare
6 - Meteoroid

 

Thank you so much for looking to this @atcodedog05

@atcoded the two below screenshot shows the action property.

 

fikeramare_1-1635338385984.png

 

fikeramare_2-1635338453477.png

 

 

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @fikeramare 

 

Can you share complete snapshot till below of the 2nd image like first snapshot.

fikeramare
6 - Meteoroid

@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. 

 

fikeramare_0-1635338605015.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @fikeramare 

 

Not sure debugging it. When you run it has a workflow does it work?

fikeramare
6 - Meteoroid

Yes, it run with no error but it doesn't display any record.  

atcodedog05
22 - Nova
22 - Nova

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 😅

Labels