see the attached
I opened your book and you were joining the 2 data sets - to correct the issue I had to download the data into csv files (could have been excel)
then Put them in a single folder and loaded into excel - I manually created a union - could have used a wildcard and had no problem
it results in this
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.
union with wildcaard union.twbx 235.6 KB
i got it