Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am connecting to a workbook in SharePoint the data is updated daily and so far it loads fine when I go to load data. However a new workbook is created with each new month so in order for me to append the new months data I would need to connect to a new URL/pathway.
The field headers are all the same. When I go to create a new connection would I be adding a new load statement with the different pathway and then once it loads will the tables merge since the field headers are the same or will it try to differentiate them? I’m just trying to add that data to the same table but url/pathway with each new month will be different. Thanks.
Couple options (assumption - Versioning is turned on for the library)
In both options, with versioning turned on, you would be able to restore to any previous version (month) if need be.
No need for a new URL / path
Thanks for the reply,
It is all new data for the new month so it would need to be the second scenario, but because new data is added daily to the workbook wouldn't I have to manually add the new rows to the version daily in order to keep the same URL I was hoping I could just do load data directly from script editor once a new pathway was created.
data is refreshed daily but the workbook changes monthly. Thanks.