My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

What Is The Smartest Way To Combine/Update tables while blocking duplicates ?|Power Query|Excel Forum|My Online Training Hub

You are here: Home / What Is The Smartest Way To Combine/Update tables while blocking duplicates ?|Power Query|Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
What Is The Smartest Way To Combine/Update tables while blocking duplicates ?
Avatar
Robert Wiggins

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
March 27, 2024
sp_UserOfflineSmall Offline
1
March 27, 2024 - 9:24 am
sp_Permalink sp_Print

My goal is to find dynamic way to update main sheet with data inside new tables I get on a daily basis without overwriting main file.  In simplified example, I work with widgets.   

 

BREAKDOWN OF SHEETS IN FILE(Main, Day1, Day2 and FinalResult)

The "Main" sheet is the primary sheet where I've made manual updates.

Day1update and Day2update are examples of the incoming sheets that I need to merge/append to the "Main" sheet.

Problem #1 -  Update sheets have different headers that I need to merge into main.

Problem #2 -  When I merge new update sheet,  it overwrites original row and my updates are gone.

OUTCOME FILE:   Would like to have output to look like "FINALresult" sheet .

RESULTS NEEDED: 

1.All headers are merged in one sheet. 

2.  Only "new" Widgets in update file are only added to main file if it currently doesn't exist.

3.  Manual edits (Seen in Orange in Final Results sheet) are not overwritten.

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1619
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
March 27, 2024 - 9:38 am
sp_Permalink sp_Print

Hi Robert,

Did you mean to attach a file?

After selecting the file you have to click on Start Upload.

Phil

Avatar
Robert Wiggins

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
March 27, 2024
sp_UserOfflineSmall Offline
3
March 27, 2024 - 10:02 am
sp_Permalink sp_Print

I tried and got a critical error.  Let me try again.

Avatar
Robert Wiggins

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
March 27, 2024
sp_UserOfflineSmall Offline
4
March 27, 2024 - 10:05 am
sp_Permalink sp_Print

File Attachment here

Avatar
Robert Wiggins

Active Member
Members
Level 0
Forum Posts: 4
Member Since:
March 27, 2024
sp_UserOfflineSmall Offline
5
March 27, 2024 - 10:08 am
sp_Permalink sp_Print

Sorry for so many replies.  I'm not sure how to edit original post.  If nothing else, I'm sharpening my addition skills...hahaaha.    File has been uploaded.  Thanks for the help.

- Robert

Avatar
Alan Sidman
Steamboat Springs, CO
Member
Members


Trusted Members
Level 0
Forum Posts: 206
Member Since:
October 18, 2018
sp_UserOfflineSmall Offline
6
March 28, 2024 - 3:38 am
sp_Permalink sp_Print
sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1944
SunnyKow: 1432
Anders Sehlstedt: 956
Purfleet: 415
Hans Hallebeek: 377
Frans Visser: 351
David_Ng: 318
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Tiago Braga
Rehan Baig
Fred HORVATH
Silke Schmidt
Stuart Barr
Amelia Nolte
David Wier
T P Collins
Gerry Khoo
Jessica
Forum Stats:
Groups: 3
Forums: 25
Topics: 7149
Posts: 31372

 

Member Stats:
Guest Posters: 50
Members: 34653
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen