Dynamic list of column values for data filteration

Question

Hi Community,

I am creating an analytic app and want make a list of column values dynamically then further use those values for data filteration, how can i achieve it ? Can anyone help ?

Thanks in Advance !

unknown · Answer

Hi @davidskaife,

Thanks for the reply, the column name will dynamic each and every time, means user will select which column(and column values) they want to use for filter. Here i want no manual intervention.

davidskaife · Answer

Hi @Inactive User

For the second part you can create a macro that reads in the field(s) you want to filter on, and updates a Dynamic Filter tool so it will process each column that is required:

For the first part are the column names going to change, be static, or be user selected?