Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

User Input to be used as a value to filter not working

nshah48
7 - Meteor

 I am using a text-box tool and the action tool for user input to enter a state and based on the state entered the filter tool should generate the report to just display data for just the state entered. I have the flow as an app. When the app prompts for the state, no matter what state you enter the filter does not update but instead uses the default value given in the filter tool. Here's the my flow. Any help appreciated.

5 REPLIES 5
Blake
12 - Quasar

Hi @nshah48

 

I used a dropdown instead of a text box so that you can control user inputs. I tried uploading the .yxwz but it keeps getting kicked back for some reason. Following the directions below. 

 

1. Use a drop down and set the list values to "manually set values". I have included a list of states/abbreviations below the screenshot. 

 

nshah48_1.png

 

Use the following for your manually set values in the drop down tool

Alabama:AL
Alaska:AK
Arizona:AZ
Arkansas:AR
California:CA
Colorado:CO
Connecticut:CT
Delaware:DE
Florida:FL
Georgia:GA
Hawaii:HI
Idaho:ID
Illinois:IL
Indiana:IN
Iowa:IA
Kansas:KS
Kentucky:KY
Louisiana:LA
Maine:ME
Maryland:MD
Massachusetts:MA
Michigan:MI
Minnesota:MN
Mississippi:MS
Missouri:MO
Montana:MT
Nebraska:NE
Nevada:NV
New Hampshire:NH
New Jersey:NJ
New Mexico:NM
New York:NY
North Carolina:NC
North Dakota:ND
Ohio:OH
Oklahoma:OK
Oregon:OR
Pennsylvania:PA
Rhode Island:RI
South Carolina:SC
South Dakota:SD
Tennessee:TN
Texas:TX
Utah:UT
Vermont:VT
Virginia:VA
Washington:WA
West Virginia:WV
Wisconsin:WI
Wyoming:WY

 

 

2. Make sure your filter is set to replace the default operand in your filter. 

nshah48_2.png

 

That should be it!

afv2688
16 - Nebula
16 - Nebula

Hello @nshah48,

 

I can already see the problem. On your action tool, (screenshot2) you have selected the Filter(19). you need to select the Expression.

 

After that go to the bottom part and check the change a specific string and just leave there MI, which is the part you want to change.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

 

 

danilang
19 - Altair
19 - Altair

Hi @Blake 

 

The Community doesn't allow app files (*.yxwz) to be uploaded.  No idea why.  You can get around it by exporting the app to a .yxzp package and then uploading the package. 

 

Dan

Blake
12 - Quasar

Thanks @danilang! I really appreciate that bit of knowledge! 

 

Blake

nshah48
7 - Meteor

@Blake,

 

That worked perfectly! Thanks a ton. I had my update default pointing to filter instead it had to be operand-value. Also thank you for the drop-down idea.

Labels