Discussion board where members can get started with Qlik Sense.
I know this is a silly, simple one, but I cannot figure it out.
I have a load statement that is loading data from an excel sheet - however, what I'd like to do is to specify a certain cell to import.
e.g - I only want to import the data from E6 on the Data sheet for example.
Thanks in advance all, I do appreciate it.
Go to Solution.
Try like below,
Sourcefile.xlsx (ooxml, no labels, table is Sheet1) WHERE RecNo() = 6;
Here, "E" is column name as we have mentioned no labels for headers. Recno() specifies the cell address. Let me know.
Perfect, thanks Tamil,
it was getting the RecNo() syntax in there which I was not doing.
Thankyou very much.
You are welcome.