Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

getting the name of a loaded TABLE from an Excel file

Hello,

Do you know any idea of getting the name of table loaded from an Excel file? Similar to filename() as File.

I have a spreadsheet with multilpe sheets, if I leave "table is" then all sheets are laoded, I would however need to know from which sheet data was retrieved.

   

LOAD


Comments,

TableName() as Table (???) - doesn't work


FROM
[..\Desktop\SE17.xlsx]
(
ooxml, embedded labels, header is 3 lines

);

1 Reply
Not applicable
Author

Hi,

is the structure of metadata the same for all sheets?

If so, one way would be to create ODBC connection to excel file and read name of each sheet (as it was proposed in the answer of http://community.qlik.com/message/223895#223895 post). Now, in load statement you can add new field, e.g. '$(zSheet )' as sheetName. Value of that field provides information from which sheet row was read.

regards