Append weekly data into a base table

Hi all, 

Is it possible to refresh a dataset weekly by appending new data into a base table? If I do an append query like base +week 1 and then base + week 2, I think it will only replace the week 1 data with week 2 data?

Thanks, Oskari