This error should indicate that the referred field name does not exist. The reason could vary.
- Naming is case sensitive. Check that your script field name is spelled exactly as in source.
- Source field name has blank character that changes the fieldname from "UserName" to "UserName "
- The load targets incorrect source table
- XLSX file has header, meaning there are empty lines above the intended header row
For example the attached XLSX file can be loaded with a load statement like this...
LOAD UserName, FamilyName, GivenName, "Group", "Rad Admin", Role FROM [lib://MyFolderConnection/QC-281312.xlsx] (ooxml, embedded labels, table is Sheet1);
You can do a wildcard load to see which field names the Qlik engine gets from the source. You can comment the current filed definitions and add a wildcard star in the load statement...
LOAD * // UserName, // FamilyName, // GivenName, // "Group", // "Rad Admin", // Role FROM [lib://MyFolderConnection/QC-281312.xlsx] (ooxml, embedded labels, table is Sheet1);
You can evaluate the loaded field names for example through Data Model Viewer.
QC-281312.xlsx 9.2 K