Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
);
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