Forum Discussion
Load was cancelled by an error in loading a previous table.
Hi Anonymous
Have you solved your issue?
If not, after seeing your screenshots I've got a long shot answer. Skip to the end for a possible quickfix.
Because:
a) I see you've recently archived the datasources.
b) I see that you select the folder and then apply some filter.
c) You have used automated transform functions.
d) You don't see any specific error.
It could be that some query is now getting both archive and current file, hence some steps later on it errors due to duplicates, or because the transformation function is tuned to the previous file, there were changes inbetween the archive and new version, thus not giving the desired results.
Now, in query editor everything seems fine, but that's because we're only getting the first 200 values and checking the first 1000 values -- if I remember the numbers correctly; I may be wrong on that.
About d), if you don't see any specific error but if it stops at evaluation, you should know you've got a column issue, but if it stops while trying to load data then it could also be a value issue. If it stops after loading everything, this could point to a column mismatch between evaluating the queries at 0row level and evaluating the queries.
Try quickfix:
Anyway, before (un)checking enable load on every query or actually changing any query to remove your issue, you could:
1) try to revert back to the archived by geting the new files to a different folder temporarily and see if it works.
if 1, 2) take the archived in a different folder and see if it works.
But if you're actually loading one file at a time then you should be using multiple file transform functions.
Cheers