Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mwallman
Contributor

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

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

3 Replies
MVP & Luminary
MVP & Luminary

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

Maybe something like this:

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

- Marcus

mwallman
Contributor

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

Thank you Marcus I will try this

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

Hi,

maybe like this:

QlikCommunity_Thread_217897_Pic1.JPG

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