Log In
Register
Home
Power Query
Power Pivot
August 14, 2022
Offline
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
Moderators
January 31, 2022
Offline
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.
1 Guest(s)
