valuechained
Board Regular
- Joined
- Oct 24, 2007
- Messages
- 63
Hi experts,
I wonder whether you could help me with a particularly tricky problem that I havent been able to solve for a while now.
I have an excel index of various data base sets. The excel spreadsheet maps out
1) the name of the data set
2) the primary key of the data set (or sometime two primary keys that concatenate into a new one)
3) the secondary key of the data sets
Naturally, if I change the primary key of one data set, I would need to change another data set that contains this primary key as a secondary key. To complicate things, some data sets have identical primary keys.
I would like to build a functionality that looks through this table and displays in a cell next to the data set name, the names of the data sets that would need to be changed if I made change to its primary key.
I have build a short table. The column that I would like to generate is highlighted in blue (I did it manually).
Thank you guys, any thoughts would be highly appreciated! Best
I wonder whether you could help me with a particularly tricky problem that I havent been able to solve for a while now.
I have an excel index of various data base sets. The excel spreadsheet maps out
1) the name of the data set
2) the primary key of the data set (or sometime two primary keys that concatenate into a new one)
3) the secondary key of the data sets
Naturally, if I change the primary key of one data set, I would need to change another data set that contains this primary key as a secondary key. To complicate things, some data sets have identical primary keys.
I would like to build a functionality that looks through this table and displays in a cell next to the data set name, the names of the data sets that would need to be changed if I made change to its primary key.
I have build a short table. The column that I would like to generate is highlighted in blue (I did it manually).
Thank you guys, any thoughts would be highly appreciated! Best
question.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
2 | Name | PrimaryKey1 | PrimaryKey2 | SecondaryKey1 | Secondarykey2 | Achangeintheprimarykeyofthisdatasetaffectschangesinthesets: | |||||||||
3 | Dataset1 | KeyX | KeyO | KeyT | Dataset3,Dataset4 | ||||||||||
4 | Dataset2 | KeyY | KeyX | KeyP | Dataset1,Dataset3,Dataset4 | ||||||||||
5 | Dataset3 | KeyO | KeyX | KeyY | Dataset1 | ||||||||||
6 | Dataset4 | KeyO | KeyY | Dataset1 | |||||||||||
Sheet1 |