Forum Discussion
Using PowerQuery to move and store records being generated in one table to a "Master" Table
Hi fraljones ,
if my understanding is correct, this should do the job: https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/
Not sure if I understand, but have you tried the append function in Power Query using new table to join the two tables together in a third table, and then delete uneeded columns? Maybe you can give us examples?
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Nathaniel_C I updated the below chart to better explain my problem:
As mentioned in the chart, I am having difficulties trying to figure out how to:
1. Send new records from Table #1 to Table #2
2. Keep all old data in Table #2
Thank you for your help Nathaniel.
Ok, going off line, but will be thinking about that and get back to you tomorrow. Clear and concise explanation.
Nathaniel
Hi fraljones ,
Tried various methods, I think you are going to have to export your table 1 to a folder as .csv or Excel file. Then use import all files in a folder. I am sure that each csv could be renamed by including date, So Table1 5/12/2019 or something like that using VBA. Then use Import from Folder. KenPuls has written a great book with Miguel Escobar M is for (Data) Monkey In Chapter 4 Importing All Files in a Folder he shows how to do this very easily.
So you could get his book on Amazon quickly, or perhaps ImkeF might have suggestions for you, or here is a Link to support office . Microsoft office support on this subject.
Good luck!
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHi fraljones ,
if my understanding is correct, this should do the job: https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/