Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

binuacs
21 - Polaris

@ppatane one way of doing this

Screenshot 2023-07-21 065505.png

ppatane
8 - Asteroid

@binuacs 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

@binuacs 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

binuacs
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, @binuacs . Thank you again!

Labels
Top Solution Authors