Why are the wrong values loaded from my QVD?

[mmarchese]

Am I doing something wrong or is Qlik malfunctioning?  Why are the wrong values being loaded into the data model?  This is happening with my other QVDs too.

SQL Server (correct values):

QVD (correct values):

Data model (wrong values):

Load statement:

Dim_ScrapTracker:
LOAD
    %scrapTrackerId,
    [Scrap Tracker]
FROM [lib://folder - QVDs/Dim_ScrapTracker.qvd] (qvd);

Update:

I realized Qlik brings in the data correctly if I load this table in isolation or load it first.  But if I load the fact table containing that same key field (%scrapTrackerId) first, then the values in this dimension table get shuffled around.  This is truly baffling.

[marcus_sommer]

How does it look like if you put these fields within a table in the UI?

- Marcus

[mmarchese]

@marcus_sommer 

It matches the data model.

[mmarchese · Accepted solution]

Ahhhhh, I figured it out.  I put this at the end of the script to be clever and then totally forgot about it:

AutoNumber '%*';

In this case, if the dimension table is loaded first, the auto-numbering of %scrapTrackerId just so happens to match the original numbering of that field, obscuring the fact that AutoNumber was used.  In contrast, if the fact table is loaded first, the field ends up with different numbers.

Lesson: Don't be a fool and forget that you used AutoNumber!  Disable it before debugging such fields!