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, embeddedlabels, headeris 3 lines
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.