Forum

Combine Queries &am...
 
Notifications
Clear all

Combine Queries & Append and avoid duplicates

2 Posts
2 Users
0 Reactions
199 Views
(@erwinvantrier)
Posts: 10
Eminent Member
Topic starter
 

My friend at work manages financials for IT Projects and Programs.

He has his monthly forecast but struggles with matching his actuals and accruals.

 

The finance departments distributes the Actuals&Accruals XLS file every week. (File=Weekly_Feed). Every file contains all data from January 1 to the date the file was sent.

The file contains errors as it doesn't always include the IO for every line item. Through research my friend determines the IO.

He copies the Weekly_Feed file he receives on week 1 and makes it his running file where he adds his corrections and adds notes (File=YTD_Corrections).

I think that Power Query is the way to go here.

 

Step 1 for Weekly_Feed

Get Data>From Table/Range>Close&Load>Only Create Connection

Step 2 for file YTD_Corrections

Get Data>From Table/Range>Close&Load>Only Create Connection

Step 3 Combine both queries

Get Data> Combine Queries > Append.

 

I only want to append those line  items from Weekly_Feed that are not already included in YTD_Corrections.

Not sure how to make that happen

__PRESENT

 
Posted : 17/12/2023 10:29 am
Riny van Eekelen
(@riny)
Posts: 1194
Member Moderator
 

Would be helpful if you could share some examples of the weekly and corrections files. Without disclosing any confidential information of course. But leave the file structures exactly as they are in real life. Just add some fake data demonstrations the kind of errors that occur in reality.

 
Posted : 17/12/2023 11:34 am
Share: