Drop-Down Menu and Join Descriptions from a separate input file

Question

Hi all,

I have two input files, the first one where I have a typology value and a score associated to the value (Image 1). The second file has the same typology value but with a description associated with the value (Image 2).

I want to do a drop-down interface in Alteryx Apps where the description is appended into a column from the table in Image 1 depending on what score it is. For example, with the drop-down menu, if I chose A and the score in the workflow returns 20, it will then add a column with the description "Since A was a score 20, return this cell".

1. I need help in having the drop-down menu show the options of the score I choose (10, 20, 30, 40, etc...) as I can only see the datatypes and I tried the other options which show no connection (Image 3)

2. I also need help in how to approach this, as I think I will need to do a formula tool where it shows "If I chose option A in the drop down in file 2 and it also shows A in file 1, return this description in file 2" or I do a join depending on what value is chosen.

Thank you ! I have also attached the workflow and my current settings and an image of what I want the output to look as a table (Image 4)

1.png

2.png

3.png

Sample_Workflow.yxwz

4.png

OTrieger · Accepted Answer

@nafong 
Yes, you are right a Join tool will do the work.

You can do it in several ways, with 2 drop down when you select A, B, C or D etc, and one for the score 10, 20 etc.
Or you can create one drop down with A 10, A 20, .....B 10, B 20 etc with all the options and then Alteryx will use it for the Join tool to get the description.

For file 2 you will need to have, or at least it will be easier to get the result from the Join, by having 2 fields, one for the letters and one for all the different type of descriptions, and you can get the score out of the description - You can get it with Transpose Tool Grouping on Value. Then Join by letter and score and you will get the corresponding description