Dynamically Select Columns Based on Query Input from Analytic App

[Link86]

I have a dynamic query in an analytic app. One of those questions in the app asks to select a month that will adjust the query. I would also like that same question to adjust a select file that reads from a flat file to show only that column in the select tool. Note: the flat file has every month of the year. Is there a way of doing this?

Example: If the user chooses 10 in the query, I only want to the October column from the flat file so that I am able to validate the data from the database and the flatfile.

Thank you.

[DataNath]

How does something like this look, @Link86?

We just check that the field isn't a month and then return the month corresponding to the month number selected in the dropdown. Here's a couple of runs: