Best Way to Append New Records to an Existing Multi-Worksheet File

[kkkim]

Hi, All:

I am relatively new to Alteryx so this might be something very simple - I have a worksheet that has around 10 tabs. This worksheet gets updated on a montly basis with new records. We want to keep one "master file" where manual revisions can be made - then every month, this "master file" would need to be updated to add on new records.

The tricky part is that certain columns (in the existing master file) need to be updated with new information with calculation done in Alteryx every month. 

Is there a simple way to keep the master file (with 10 tabs and with manual changes made), then append new records on a monthly basis and do calculation for columns (so it will contain new information) on a monthly basis?

Hope this makes sense. 

Thank you for your help!

[BA02]

Hello, I am not sure if I understand your ask completely. Can you please share some sample data?

As far as the appending is concerned, yes, it is possible.