Best way to show data as a dropdown? Not Data filter.

[#1]

Hi all,

I’m working with two data tables that I’ve joined using primary and foreign keys and they have thousands of data. My goal is to display values from these tables in dropdowns ( currently I am using ComboBoxes), and based on the selections, generate subset or transposed tables dynamically.

Currently, I’m using ComboBox to populate unique values from the data tables, but performance is quite slow and especially with larger datasets. I’ve found that JMP’s built-in Data Filter is powerful but not very customizable for UI integration.

Is there a way to leverage the Data Filter engine behind the scenes and connect it to custom UI dropdowns? Or is there a more efficient approach to achieve responsive, dynamic filtering as a dropdown in JSL?

Any suggestions or examples would be greatly appreciated!

Thanks in advance.

[#2]

I would think it will be a quite bad experience for the user to scroll through 20k entries in combo box even if it did work properly. You could instead, for example use List Box with additional search, which could be better user experience. You can create one with JSL using Text Edit Box + List Box or use data filter or filter col selector for example. 

[#3]

Thank you for sharing this script. Indeed this script accurately depicts the issue that I am facing.