Pathways for finding data

KNIME Analytics Platform
1

I have a functional workflow that allows someone to load a list of ID values and then have it return data from various DB tables based on those values.

I am trying to figure out if there is a way to allow for multiple paths to getting data results, such as but not limited to:

  1. A search dropdown of all IDs that are available.
  2. A dropdown of all countries that have relevant data.
  3. A dropdown of all entity names that have relevant data.

Is there a way to have someone pick what path and then allow them to pick a filter or load the file?

Thanks for any insight on how something like this might work.

2

Hello @aehrenworth,

I think you are looking for the Value Selection Widget

It lets you choose which column populates the drop down with the values for that column. You would probably need to query the database for those 3 cases you have and pass it to the selection widget.

  1. Query all ID’s in your database (something like SELECT DISTINCT id FROM my_db – here I would make sure to use distinct so you don’t get duplicate id’s), pass to value selection widget, use the selection via flow variable to pass to another query for further processing on that specific id
  2. Same process as 1
  3. Same process as 1

Let me know if this is what you were looking for,
TL

1 Like