That didn't work for me - but it might be pointing toward my problem.
My source is a spreadsheet file. I think it might be loading these records for blank rows at the end of my data.
I have added a condition to my where clause:
where len(Order_Num)>0, and it seems to get around the problem.
But I suspect I may have records in the future without a value in Order_Num; and I WILL want to load these fields (but they will be excuded by tha above condition).
Is there a way to ignore blank rows at the end of my data in a spreadsheet?
Or is this my problem in the first place?
I'd say that there is no easy way to control that. Meaning that assuming that today you have 20 rows worth of data, plus four with blanks and another two with data as well, you would need to control that if the length of the whole row (summing up the Len(Trim()) of each column) equals to zero, then do not load them, otherwise, load them.
This would allow you to perform unattended reloads irrespective the number of rows within with all blanks.
You might try to load the spreadsheets using and ODBC driver, instead of the table files wizard in QlikView, and control there which fields are key and so which rows should be always loaded, regardless the number of Order_Num or so.
The best way to get that around is doint some cleanup in the source, if that's possible.
Hope that gives you a better idea.