Feb-04-2021, 09:15 PM
So I have a production Limits management system, basically a huge table that has rows for each permutation of [Plan | subgroup | Tool | Item | Statistic | Limit] that will trigger automated events.
The problem I'm seeing is that we are tracking the limits in a table that just has [Tool | Item | limit], making it more reasonable for humans to interact with. In order to make an edit to the actual system table, a user must identify all permutations and then edit all the required rows. a lot of human glue and a lot of room for human error.
I'm wondering if python can help here? given some source tables, can it create a final edit table with all permutations? I'm able to run a query and get a list of all [Items | Plans | subgroup], basically a pivot summary.
Here's an example of what I'm looking at. first pic: a pivot summary of permutations of Item|Plan|SubGroup. noting that not all Items are in all Plans and not all SubGroups are in all Plans.
pivot summary of Item|Plan|SubGroup
Second table is an example of how the Operators manage the limits, on an excel sheet for easy reference.
Limits table
The result I'm trying to figure out is how to script so that there's a final output table with all permutations of the source tables.
Any advice on where to start with this in Python? (or if there's a better way?)
The problem I'm seeing is that we are tracking the limits in a table that just has [Tool | Item | limit], making it more reasonable for humans to interact with. In order to make an edit to the actual system table, a user must identify all permutations and then edit all the required rows. a lot of human glue and a lot of room for human error.
I'm wondering if python can help here? given some source tables, can it create a final edit table with all permutations? I'm able to run a query and get a list of all [Items | Plans | subgroup], basically a pivot summary.
Here's an example of what I'm looking at. first pic: a pivot summary of permutations of Item|Plan|SubGroup. noting that not all Items are in all Plans and not all SubGroups are in all Plans.
pivot summary of Item|Plan|SubGroup
Second table is an example of how the Operators manage the limits, on an excel sheet for easy reference.
Limits table
The result I'm trying to figure out is how to script so that there's a final output table with all permutations of the source tables.
Any advice on where to start with this in Python? (or if there's a better way?)