Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe something like this:
load A as DateType, B as Date From YourExcel where wildmatch(A, '*Date*');
- Marcus
Thank you Marcus I will try this
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