If I understand the question you are trying to append a 1 day dataset to and existing data to create a daily update? is that correct?
see the link on wildcard union as an approach
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.