Hi all,
I have following problem. I would like to compare several tables.
I have a short listed table
| Name | category | stage | Feature 1 | Feature 2 | Feature 3 |
| A | AAA | aa | X | Y | |
that I would like to compare to a long listed table
| Name | category | stage | Feature 1 | Feature 2 | Feature 3 |
| D | AAA | bb | X | K | |
| E | BBB | cc | X | Y | Z |
| F | AAA | aa | V | K | J |
| A | AAA | aa | X | Y | |
using a third table with feature relationships
| Feature 1 | Feature 2 | Feature 3 | Feature 4 |
| X | Y | Z | K |
| V | K | J | |
the output should be the short listed table with additional columns
| Name | category | stage | Feature 1 | Feature 2 | Feature 3 | same_aa | same_bb | same_cc | related_aa | related_bb | related_cc |
| A | AAA | aa | X | Y | | 0 | 1 | 0 | 1 | 0 | 0 |
the additional columns should one based on the following criteria form the long list and feature relationship:
- exclude the one with the same name
- only consider lines within the same category
- sum up by stage names that have same or related features
- same feature is when the line has one of the same features
- related feature is when the line has a related feature based on the related features table (e.g. F is related to A)
- lines considered as same should not be accounted in related any longer
Of course I have more than just one line / features etc.
I would be super helpful for some general input on how to compare different sheet, workflow would be of course appreciated too 🙂
Thanks, -L
