In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Choose the row of data to get from a spreadsheet

ppatane
8 - Asteroid

I have many tables of information in which I need to be able to question the user which row of data do they need. I'd like to have a list box with the States listed in it and then have that row of data export to a spreadsheet.  Is this possible?
(I added the workflow I was trying to create to extract the state)

 
 

Community.jpg

7 REPLIES 7
StellaBon
11 - Bolide

@ppatane You can do this using an Analytic App. Watch the first 3 interactive lessons and the one on List boxes to learn how. 

See:https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2... 

 

StellaBon

binu_acs
21 - Polaris

@ppatane one way of doing this

Screenshot 2023-07-21 065505.png

ppatane
8 - Asteroid

@binu_acs Grazie!  This is ideal!  I see I was getting close but missing some key points.

ppatane
8 - Asteroid

@StellaBon Thank you for the links...they will be quite necessary for a novice like me!

ppatane
8 - Asteroid

@binu_acs Some of our users with a newer version of Alteryx cannot run the workflow.  Anyone with ideas as to how to get around this? This is what's not available in the newer version.

Imeldas.jpg

binu_acs
21 - Polaris

@ppatane This workflow was created from the latest version of the Alteryx. I updated the workflow by removing the replace function from the filter tool. Can you try now?

image.png

 

ppatane
8 - Asteroid

Sure enough, @binu_acs . Thank you again!

Labels
Top Solution Authors