Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

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
marcus_sommer

Maybe something like this:

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

- Marcus

mwallman
Creator III
Creator III
Author

Thank you Marcus I will try this

MarcoWedel

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