community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The latest release includes several enhancements designed to improve your Community experience!

Learn More

Retreive Column names from the selected table using Dropdown

Highlighted

Hi Team,

 

I have a requirement that I need to list down all the columns from a selected table in the Drop Down input. 

 

  a Dynamic Columns.pngSelect Dynamic Column names based on the selected table name

For listing down all the table names from the database, i have used "External Source " option of Dropdown toolbox. 

But I am unable to get how to select column names from the selected table name using another dropdown. 

 

I need to get list of all columns from the selected table from the dropdown option. 

 

Kindly let me know if there is any other way to do it. 

 

Alteryx
Alteryx

Hi @RaghavendraBoralli

 

This is the way I have seen clients set this up dynamically before. 

 

The file input allows the user to choose a table and then based on the table the columns are passed into a list box for them to select and only those fields continue through the remainder of the workflow.

 

pic1.png

 

I have a attached a workflow built in V11.0. 

 

Best,

 

Jordan Barker

Solutions Consultant

Hi Jordan,

Thank you . This helps.

Regards
Raghavendra
Labels