Isn't the load tool suppose to parse the endYears as follows(?):
split(coalesce(row.`Artist End Date`,'9999'),'|') AS endYears
The way it is right now generates 76 artists w/o endYear.
On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.