Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Filter via user inputs from text box

nkjy
5 - Atom
‎09-30-2022 09:08 AM

Hello, I am trying to filter the currency rate based on inputs from user (eg. JPY) however I am struggling to configure the action tool to have the variable inside the formula in my filter tool. Any kind soul able to help out here please.

forexapi.yxwz
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
jzkyburz
8 - Asteroid
‎09-30-2022 09:13 AM

You were really close! You just needed to put quotes around your variable in the filter: 

 

'[#1]'

forexapi.yxwz
Reply
0 Likes
Kakuffo
Alteryx
Alteryx
‎09-30-2022 09:13 AM

hi @nkjy  if you replace the #1 with "[#1]" and then have the action tool replace "[#1]" it should work for you ive attached my version, which i used a currency abbreviation in place of the [#1]

forexapi.yxwz
Reply
0 Likes
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All