I'm pretty new to qlik and trying to debug a load script I inherited. I have a local data folder with an excel doc (excel 2016, so xslx). I try to load data from the doc and the first column in the document is not found. I've tried everything I can think of as far as converting to csv, different versions of excel docs and it seems to always com back to the same thing, anyone have an idea?
Here's the relevant part of the load script:
Role as UserRole,
"Group" as UserGroup,
"Rad Admin" as RadAdmin,
upper("Group") as REDUCTION
FROM [lib://LocalData (r3_john.morgan)/CMB003AuthorGroups_Tagged.xlsx]