Forum Discussion
Lookup Table change with time
Excuse my title, as I wasnt sure what to name this topic. I have a lookup table that uses an employee number to tell what budget group someone is in. One of the employees here is moving to a different budget group and I am not sure how to have the data reflect that without affecting previous years. I am attaching some screenshots to reference
The Employee Number cannot change.
10 Replies
v-juanli-msftCommunity Support
Hi Anonymous
From your screenshot, i'm not clear about which are "budget group", "previous years","employee number".
"One of the employees here is moving to a different budget group (change) and I am not sure how to have the data reflect that without affecting previous years. "
How do you create this lookup table?
(from another table called "source table" here ?
does the "change" occur in "source table"?)
Best Regards
Maggie
v-juanli-msft wrote:Hi Anonymous
From your screenshot, i'm not clear about which are "budget group", "previous years","employee number".
"One of the employees here is moving to a different budget group (change) and I am not sure how to have the data reflect that without affecting previous years. "
How do you create this lookup table?
(from another table called "source table" here ?
does the "change" occur in "source table"?)
Best Regards
Maggie
I can see how my question was a bit unclear. So my expenses sheet is shown here. The employee number is used ina lookup table to find budget group.
Then we have the original lookup table that I provided. So from 2016-2018 Employee # 13472 was a part of STEER. In 2019 they will be moving to Training H. It is not possible to change their employee number because of how the data is reported. I am trying to find a way to make this changes while ensuring that they are still in the correct budget group for 2016-2018 (STEER).