Populate drop down with values from connected tool

mb1824

Hi,

I am trying to build an App, where the user is prompted to choose the value of  [Index] (e.g 5) that updates the value in the Select Records tool

I have got it to work using a Numeric Up Down tool where I manually set the conditions of [Index]...see attached workflow

However, I would prefer the user selected from a drop down, which is populated with the values of [Index] from the same Input.This way if Index '11' suddenly appears in the source data, I don't have to update the Maximum in the Numeric Up Down tool. 

I have looked at the example for the Drop Down tool and it seems the 'Fields from Connected Tools' option is for the User to select the 'Field Name' rather than the 'Field Value'. I have got around this by including a Cross Tab tool (see second workflow) but wondering if anyone has any better ideas?

DropDown.yxzp

Numeric Up Down.yxzp

Claje

Hi,

One of the options in the Drop Down tool is to connect to an External Data Source.  You can use this to connect directly to a database or file to populate the drop down.

I'm going to make an assumption that your data is in a SQL database, although this should apply for other technologies.

You would connect to your SQL Database using the External Data Source option, and then write SQL something like the following:

SELECT [INDEX] [NAME], [INDEX] [VALUE] FROM TABLE GROUP BY [INDEX]

This will pull a list of all existing indexes from your table.

The reason we call out the [INDEX] column twice in our SELECT and rename it to NAME and VALUE is because the Alteryx Drop Down tool expects a NAME (the value the user sees) and a VALUE (the value that is passed into the app).

If you had a name column in your database that the user was more familiar with than your index numbers, you could replace the first INDEX in the SELECT statement with a different column, and it would display that front end value.

Hope this helps!