Forum Discussion
Parameters - filter issue. Bridge table?
Hi all, I have quite big table with work orders (approx 40k rows). A snipped would look like that: UID DateTime Status Shift Unit Machine WO001 01/01/2024 13:55 In progress A Unit...
Is there any other way?
I was trying to create like a bridge table listing all possible values/combinations and then connect it somehow to main table but this failed as well.
If not, I will have to rebuild it although i'd prefer to have all fields available even if they do not havey any data that could be displayed for them. 🙂
You could create the bridge tables then in the query editor do cross joins to each.
That would create a table with every possible combination.
Then create a column combining them all in to a key.
Create a new column that combines them in your main table also.
Join the two using the key.