Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Validating the User Input in Input tool

pgayath1
8 - Asteroid

I am using interface tools i.e., input tool to seek input from user.

 

Input can be like LL1, LL2, LL3, LL4, LL5, LL6. If the user enters other the mentioned, it shall throw error and should not proceed further until valid input is keyed in input tool.

 

How can I achieve this?

 

Please help. Thank you.

5 REPLIES 5
MarqueeCrew
20 - Arcturus
20 - Arcturus

@pgayath1,

 

You will need to use an ERROR MESSAGE interface tool.  Here's a sample configuration checking for the ZZ9 pattern (2 uppercase letters followed by a single digit).  If the pattern (as you posted) is different, you'll need to update the expression.

 

capture.png

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
pgayath1
8 - Asteroid

thank you, I need to restrict the user to key in only LL1, LL2, LL3, LL4, LL4, LL6. Should not allow other alphabets or other numbers after alphabets.

 

Should I hard code my characters there?

MarqueeCrew
20 - Arcturus
20 - Arcturus

If I understand you, the contents can be:

 

LL1

LL2

LL3

LL4

LL6

 

One value and only one of each of these values.

 

[#1] NOT IN ("LL1", "LL2", "LL3", "LL4", "LL6")

 

cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
MarqueeCrew
20 - Arcturus
20 - Arcturus

... but you could also use a DROP DOWN tool with a manual configuration of:

 

LL1:LL1

LL2:LL2

LL3:LL3

LL4:LL4

LL6:LL6

 

or 

 

LL1

LL2

LL3

LL4

LL6

 

or

 

description of LL1:LL1

description of LL2:LL2

description of LL3:LL3

description of LL4:LL4

description of LL6:LL6

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
pgayath1
8 - Asteroid

If I use Listbox, with  more than one input i.e., multiselect, how to pass the list of values to the dynamic input tool to query the database.

 

My input values can be LL1 and LL4 or all

Can you show this in workflow?

Labels