Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Text BOX and List BOX Combo - HELP Please

DrewCrow
5 - Atom

Good Afternoon genius Alteryx minds- 

 

 

I am fairly new to this program and need assistance if this is even possible. 

 

So basically I want to have a list of something in this examples is SCAC's .  Then I want to be able to enter different Delivery Schedule names for every SCAC on list in the interface.  So output would look like below. Below is general idea of what is needed just not sure how to get it to work. Any assistance would be greatly appreciated. 

 

 

 

DrewCrow_1-1683144988510.png

 

 

 

 

ScacDelivery Sced Name
DON'TBased on what is entered in text box
HUGBBased on what is entered in text box
PAPTBased on what is entered in text box
Test2Based on what is entered in text box
Test3Based on what is entered in text box
Test4Based on what is entered in text box
Test5Based on what is entered in text box
Test6Based on what is entered in text box
Test7Based on what is entered in text box
Test8Based on what is entered in text box
TGXUBased on what is entered in text box
5 REPLIES 5
Yoshiro_Fujimori
15 - Aurora

Hi @DrewCrow ,

 

I understand the record for [Scac] selected in List Box are all updated with the string set in Text Box.

The quote character ['] in the value "Don't" is converted underline [_] in Cross Tab tool, and it caused error at a later step.

As I could not solve this issue, I removed quote character from the list.

 

Workflow

Yoshiro_Fujimori_0-1683165763611.png

 

1st Input 

Yoshiro_Fujimori_1-1683165814818.png

 

1st Output

Yoshiro_Fujimori_2-1683165845707.png

 

2nd Input

Yoshiro_Fujimori_3-1683165883994.png

 

2nd Output

Yoshiro_Fujimori_4-1683165912512.png

 

Does it work for your case?

DrewCrow
5 - Atom

Thank you for the reply.   Yes the character " ' " didn't matter this is just a sample input .   This works kind of of what I was looking for.  Was looking to be able to update them all at once with different input values per SCAC.  The number of Scac and Scac name will vary with each run of the workflow. If have to update them individually can there be some sort of  loop until ready to go to next part of workflow ( so the would input a name for all Scac they want , they can leave blank if wanted) Then hit another finish button to move on to next step  which will take input data they provide to compare to database that contains those names and other fields of data associated with those names, in order to add to or update the delivery schedule they provided. 

DrewCrow
5 - Atom

HI @Yoshiro

Guess better way to put this would be is there any way that the check box could trigger a text box for each SCAC value checked.  Not sure just think at this point.  

 

Thank you for any additional input you can provide. 

Yoshiro_Fujimori
15 - Aurora

Hi @DrewCrow ,

 

You can call the same app on success to loop the process.

Yoshiro_Fujimori_0-1683176777444.png

 

This solution requires the user to close the file every time, which is not cool..

There might be a way, but I couldn't figure out how to use Check Box to switch the branch in the app.

 

DrewCrow
5 - Atom

Hi  -

 

Thank you for trying.  I wasn't sure if this was possible. I appreciate you looking into this.  Your workflow was helpful in pointing in right direction just not sure if  going to work for my specific situation. 

Labels
Top Solution Authors