SELECT [ACCESS], [USERID], [TEACHER_ID], [OMIT] FROM Education.dbo.Security;
TEACHER_ID is the field I am associating to the application model. I've tried different combinations of using quotes and brackets with the field names, in case there are reserved words.
When I remove the section access flag and just look at how the SQL Server data is being loaded into Qlik, everything looks fine, as you can see it does the association to the application data which adds the additional row and column:
So it doesn't look like a data type issue or anything like that...
If anyone sees what I am missing here I'd appreciate a note!