Looking for a solution to load multiple multi-select drop-downs with cascading effect based on related data.
I am dealing with millions of records retrieved from an API, some of which are duplicates in one column but unique when considering all columns.
The task at hand is populating 10-12 multi-select drop-downs with API data and implementing a cascading effect in the on-change event by iterating through millions of records.
What would be the most effective approach to tackling this type of challenge?