Forum Discussion
filtering based on both columns and rows
Hi Anonymous
So this partially works. The unpivoting works as intended and end up with this based on your suggestion - if i show it in a visual:
| Ingredient | A | B | C | D | E | F | H |
| X index | 3 | 3 | 2 | 2 | 2 | 2 | 1 |
| X min | 71.8 | 27.2 | 27.2 | ||||
| X max | 72.8 | 28.2 | 1 | 10 | 4 | 2 | 28.2 |
I need this to be filtered based on the index. i.e. if the index is 2 then this table should be:
| Ingredient | C | D | E | F |
| X index | 2 | 2 | 2 | 2 |
| X min | ||||
| X max | 1 | 10 | 4 | 2 |
I can separate the index into another table if that helps.
In that case I can get to this:
| Ingredient | A | B | C | D | E | F | H |
| X min | 71.8 | 27.2 | 27.2 | ||||
| X max | 72.8 | 28.2 | 1 | 10 | 4 | 2 | 28.2 |
Which then needs to be filtered by the index table which reduces to this by using the same actions you suggested before and filtering on the index number 2 in this example:
| C |
| D |
| E |
| F |
Does that make sense at all?
As this is just the first part of a much longer process I need to keep it all virtual if at all possible. The point of this part is to reduce the table as much as possible before I start comparing with some other data, so I don't end up overloading the memory.
Thank you for your help
Best Regards
Vnue