Unable to load named tables into Qlik Sense

[liamtreidy]

Hello Community,

I am attempting to load data from excel into QlikSense. However, I specifically want to load and analyse named tables that are present within my excel sheets. At the moment, all my sheets are loaded but i can not load named tables that appear within the sheets. 

Pic 1- Excel Sheet

Pic 1- Excel Sheet

Pic 2 - Highlighted and named excel table

Pic 2- Excel Named Table

Pic 3 - Data loaded into Qlik Sense. Named table (RiskTable) is not loaded. The table that is recognised is using the wrong headers due to the format of the excel sheet. I am unable to change the layout of the excel sheet.

Pic 3 - Data in Qlik Sense

[RsQK]

Hi! When youre in the process of loading the excel sheets in Qlik, you should pay attention to this part:

adjust this so you get the real column names.