Analytic App: Eliminate underscores in Drop Down

Hi,

I have an excel sheet which has records containing spaces between strings. (E.g: Steering Wheel Trim). When I run the workflow as Analytic app, the record shows as

Steering_Wheel_Trim under the drop down list. I need to get rid of underscores.

Please suggest solutions. Thanks!

Screenshot of part of workflow

Analytic App.PNG

Apps

Accepted answers

varunamin

Hi Ben,

I used a dynamic rename and replaced underscores with spaces. So it worked.

Thank you for your help.

All comments

BenMoss

There’s a couple of methods you could use here; I’ve actually built a tool to do this, it’s in the gallery ‘cross tab real’ however it’s still in BETA and I believe there is a bug, but give that a go!

This blog post outlines a process if you want to have a go yourself.

Also are you using the same file every time? Will the values for the drop down ever change? I would be careful with your current config, there should be no steps between the file passed in and the population of the drop down. I would consider using a chained app to do this process; https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Chained-Alteryx-Analytic-Applications/ta-p/7597.

You can use your first workflow to perform the manipulation of the values needed for the drop down which then triggers the second workflow. This will prevent any conflicts that may occur by actually using tools between the input file and the interface tool which is not recommended.

https://benjnmoss.wordpress.com/2017/02/06/special-characters-and-the-cross-tab-tool/

varunamin

Hi Ben,

Thanks for the reply. Yes, the values for drop down will keep on changing. I think I won't be requiring the chained app.

I tried configuring with cross tab real tool, but no luck.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703