In my table Nomination, the following columns are there Key, KeyType, SourceKey. I want to add an augmented attribute called SourceKeyType with the following logic : For each record in Nomination, I need to find its SourceKey and find the KeyType Corresponds to that SourceKey. For example :
| Key | KeyType | SourceKey |
|---|---|---|
| 1 | GOM | 2 |
| 2 | TRA | NULL |
After defining augemented attribute
| Key | KeyType | SourceKey | SourceKeyType |
|---|---|---|---|
| 1 | GOM | 2 | TRA |
| 2 | TRA | NULL | NULL |
How to model the PQL?
