Tool to select specific rows manually like a checkbox

[SSingh1029]

Hi,

I have an benchmarking excel (created using Alteryx) which contains some potential cost savings % for specific departments in three types for each department - 25th percentile, median and 75th percentile. I want to select 1 best savings % for each department manually since it is very objective process. I can do that in excel but want to know if that can be done in Alteryx.  

[SSingh1029]

is it because of the Regex formula we are using % sign after 4 ?

[atcodedog05]

Hi @SSingh1029 

The value coming from the data in stream is it 15% or 0.15 because that changes a lot things

[atcodedog05]

---

@SSingh1029 wrote:

is it because of the Regex formula we are using % sign after 4 ?

---

Yes thats right its expecting 15% not 0.15

[SSingh1029]

i fixed that and now most of them as joining. 

Is is possible that the values i select only show in the output box in the workflow so that i can show the corresponding actual savings for them

[SSingh1029]

i mean if i can put a summarize and show the actual savings after i select few rows in the list box 

[atcodedog05]

Hi @SSingh1029 

That would be much more complicated 😶

[SSingh1029]

Got it, this has been very helpful. I learned a lot today. Thank you so much 🙂 !!!

[SSingh1029]

Hi @atcodedog05 

hope you are keeping safe and doing well !!

I am facing some error related to creation of key which is preventing me to join some of the relevant values and get an output.

For example in some of the values I am getting "_" in between words (screenshot below). In this picture below you will see that for Finance only the third option makes sense, all others have "_" after 'Finance'. This is preventing the Join to match these values with 'Option value' field which we created in the initial formula tool.

 

 I have tried to troubleshoot it but cannot find a solution. Do you have any idea why it might be happening?

[atcodedog05]

Hi @SSingh1029 

This is clearly because of the format change of percentage field it should be in format "15%" number+%. If it is not in this format the options created will fails since it not they are not following the predefined format.

I have made a slight updation so that it shows decimals for percentage.

And it needed to follow the format xx.xx% for percentage for the model to work. Hence you need to make all those data manipulation before you pass it through. And you can show any/all other columns which you want to show by enabling them in the join select window.

Hope this helps 🙂