That seems like a pretty challenging mulit-tiered process in order to do a simple stacking. However, thanks for figuring this out. Instead of doing it that way with multi-steps. I created a historical master view to be refreshed as the foundation than stacked with new data pulled from sharepoint.
On a side note, other programs have the ability to recognize changes in data per a specific data element. Maybe this would be a great idea to institute in Paxata?
Hey morning @sayyar,
As mentioned above.
I created a historical master view to be refreshed as the foundation than stacked with new data pulled from sharepoint.
Basically, automated the historical/foundational piece, then automated the share point data and created a project which stacked them together.
Manual - However, when my sharepoint data reaches its record limit. I have to export half the records and paste them into the historical master and delete them manually from the sharepoint (eliminate dupes).