Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

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

Run through database and match input data value

8 - Asteroid

Hi all,


I have a sample gender database file in .csv format which is around 100 MB in size. In the file you will see Name, Gender, Code among other field (sample attached)

What I would like to do is to input my file with name and find the gender for respective name from database file.


I would be really nice if it can calculate the count and probability ratio ( I read about this - https://community.alteryx.com/t5/Alteryx-Designer/REST-API-to-get-Gender-from-Name-and-Country/m-p/6...)


I have attached the sample database file and input file






8 - Asteroid

one solution that I can think if using Join Tool but again it will not calculate the probability...

12 - Quasar

Hi @abhishekyx 


this app will allow you to type in a name and it will return the count of that name as well as probability.