Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Regards
Jason
Hi Jason,
Try like below,
E19:
LOAD E
FROM
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.
Hi Jason,
Try like below,
E19:
LOAD E
FROM
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.
Jason
You are welcome.