Hello guys,
I am really struggling and would appreciate any help on this!
On my initial table, I have information about one person:
- person #
- country
- grade
- contract type (TR, FTA, TA)
-> I need to have the corresponding amount for each person on each row
The corresponding amount is in another table
- contract type (only 2 contract types (FTA, TA) as TR = FTA)
- country
- grade
- amount
How can I get the amount in the first table based on the table of correspondence in the second table?
Thank you so much for any support on this!!!
Bookmarks