Forum Discussion
Update a table from external file weekly
It depends on how do you use resulting data, but perhaps Power Query could help:
initiate first time the table returned by query of source file; query this result and new source, append one to another and return to the same resulting table. The only is to add some logic not to append same update several times. That could Remove duplicates if records are different, or other logic.
Thank you very much for your reply.
I am not familiar at all with Power Query, therefore you have to excuse me if I need a more detailed explanation.
This is what I currently do:
I have an old file where I copied (CTRL+C/CTRL+V) the "external" table that I was sent some time ago. In the first rows, I have added my formulas. I have converted the "external" table to Range, and made a table again including my to this master table, so I can analyse the entire dataset with pivots.
I take this file and save it with a different date and replace the "external" table this way each week.
How would Power query work in my case?
Ideally, I would like to be able to update my master table each week having a reference to the new file I am sent without having to cut&paste the table every.
Thank you in advance for your time.
K.