Log In
Register
Home
August 21, 2019
Offline
Hi Guru,
Is it possible to have a cumulative table with all historical records as base table (Jan 22, Feb 22 and Mar 22) to import to power query editor, and each month there will be a new query (current) that produce the new record of that month, for e.g. Apr 22, and append to this base table
in the past I will output the new one, i.e. Jan 22 .... Apr 22 and replace the base table, so that subsequent month, the May 22 can be appended to it
instead of having to every time overwrite the base table (updated cumulative records), can we have some function within power query editor to have the current records append to the latest base table ( looping ??) within man in the loop to output the latest to the base table externally
Thank you in advanced
See Answer
Moderators
January 31, 2022
Offline
Hi Chris,
Please see if you can make sense of the example in the attached file. You start with a "Base" table with three months data and load it back to Excel. The default name becomes "Base_2". Now, change the Base query and set the Source to "Base_2" and append "New". Close and Load.
Enter new data for May in New, refresh. Base_2 will expand and now contain Jan to May data.
R
Answers Post
August 21, 2019
Offline
Hi Riny,
will test it out, looks like the Base_2 got to add in remove duplicates to make it unique
thank you so much !
Moderators
January 31, 2022
Offline
Correct about the duplicates. It all depends on when you refresh. If you make sure that the New table doesn't contain previously added items and if you don't refresh multiple times without adding new info, then you shouldn't have to remove duplicates. But good to add it, just in case.
1 Guest(s)
