Enter Cost/number after selecting name from dropdown using alteryx analytic app

[db89]

Hi All,

I am trying to achieve utilizing names from dropdown in such a way that, i can assign a number (cost/time) against that specific name only. 

Is that possible based on the Test input file in order to get an output attached?

Thanks,

db89

[binuacs]

@db89 you can try something like below

[db89]

@binuacs hey thanks for the response! this is what i have been doing, but the problem is, it replaces the number when entered from the text box, but resets when i enter for the new person from the drop down. Say for A i entered 12, but when i select B and put 22, for A it goes back to default value. 

[binuacs · Accepted solution]

@db89 updated workflow attached, your change will get write into your input file itself

[db89 · Accepted solution]

@binuacs Thank you so much for sharing! however it is returning the default (10) value once the names are changed and a different value is entered in cost. 

[binuacs · Accepted solution]

@db89 Can you screen shot your input vlaues and output here? Below are my three changes in the same file

[apathetichell]

I think you want chained apps here so app a selection feeds to app b.

[db89]

@binuacs hey your solution actually worked, I didnt select the input as the output file and hence it was not functioning properly! Thank you so much for your guidance on this!

[db89]

@binuacs hey hope you are doing well. I just wanted a little more help understanding how to use months as a dropdown to in such a way that, if A has cost for Jan and Feb, then after selecting A's name I can select a particular month to update the cost against them. I have attached the updated sample input.