Your conclusion is correct. Table 2 has more records per date, id then table 1. The effect (in every tool) is duplication of the rows.
Perhaps a datablend (Tableau) is more suited here. Table 2 is your primary and Table 1 is your secundairy. A blend wil aggregate the data from table 1 at the desired level so it will not duplicate the rows.