โ07-18-2021 06:42 AM
The attached sample excel has three sheets:
Sheet โdataโ - This sheet has the raw dump of data
Sheet โpivotโ - This sheet has a pivot build out of the โdataโ sheet
Sheet โstatsโ - This sheet builds a summary data using the โpivotโ sheet
The goal is to refresh the pivot table in the โpivotโ sheet once new data is added in the โdataโ sheet.
Any help would be greatly appreciated.
sample_pivot.xlsx (15.4 KB)
โ07-19-2021 09:43 AM
Well you can definitely automatically refresh a Pivot Table (via a Macro/VB) - not sure how that will work with Snap reading the file. Try adding the necessary Macro/VB and see what it gives you.
โ07-20-2021 01:50 PM
If you have a database lying around, Iโd send data there through Snaplogic and have the data sheet connect to that local database so refreshing is easier.