Hi,
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.
Harold
Hi,
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.
Harold