I copied and pasted your script above to the data load editor, and brought in the table to the data model.
The Employments_x_Dates table is as shown below and before I tried to convert field type to date format, it was showing same as the next column on the right which is ReferenceDate field. Although the data load script did not generate error, and I successfully created the tables, the data field type selection will show all the values as null. I'd appreciate it if you could let me know where I am going wrong with this.
Also, in the script below, EmployedDate and ReferenceDate are exactly the same, but is this OK?
Regarding the number of rows, I kind of understood that Excel row numbers and Qlik Sense row numbers are not comparable in terms of data processing speed and efficiency as Qlik Sense calculations can only operate on columns (i.e., fields) and hence more efficient in processing big data, while Excel formulas are applied to cells and consequently use up more memory.
Thanks a lot for your help.