A join is what you want to do, but the join type is the question.
In your example data, you should only join on Date because it's the only common field
inner - will only return the data when the same date is in both data sources
left - if you add Source 1 first, you will always get Source1 values and also Source2 if the record exists
right - if you add Source1 first, you will always get Source2 values and also Source1 if the record exists.
With your sample, it doesn't matter because the same dates are in both datasets. In reality you might be missing dates in either date source so the join type does matter.
If you're still facing problems, post a twbx or more requirements on what you want to do