Hi Folks - Looking for help with a logic question on data maintenance after you download fresh data.
1. My team downloads data from a system into excel (I think Power BI could be used)
2. The data is filtered into multiple tabs based on team name (each team gets their own tab of data)
3. Each team goes to the tab with their teams data and fills in some missing content - fills in 3 empty cells with data (on the spreadsheet, not in the source data)
4. When we "refresh" the downloaded data, all the edits made by the team get overwritten and note, new rows of data may be added, etc.
What is a logical way to update the data, and preserve the edits made and add date (if needed) to any new rows of data added?
I keep thinking that we could preserve a helper table but it feels unwieldly and didn't know if anyone has any better ideas.
1. My team downloads data from a system into excel (I think Power BI could be used)
2. The data is filtered into multiple tabs based on team name (each team gets their own tab of data)
3. Each team goes to the tab with their teams data and fills in some missing content - fills in 3 empty cells with data (on the spreadsheet, not in the source data)
4. When we "refresh" the downloaded data, all the edits made by the team get overwritten and note, new rows of data may be added, etc.
What is a logical way to update the data, and preserve the edits made and add date (if needed) to any new rows of data added?
I keep thinking that we could preserve a helper table but it feels unwieldly and didn't know if anyone has any better ideas.