How can I just load the From and To date values from the attached spreadsheet please?

[mwallman]

Hi all,

How can I load only the From and To date values from the attached spreadsheet please? I'd ideally like to load the labels as well but not sure how difficult this is

[marcus_sommer]

Maybe something like this:

load A as DateType, B as Date From YourExcel where wildmatch(A, '*Date*');

- Marcus

[mwallman]

Thank you Marcus I will try this

[MarcoWedel]

Hi,

maybe like this:

Generic LOAD 1, * FROM [https://community.qlik.com/servlet/JiveServlet/download/1045045-227340/Data%20sheet%20-%20Copy.xlsx] (ooxml, no labels, table is Sheet1);

hope this helps

regards

Marco