6 Replies Latest reply: Jun 21, 2016 2:46 AM by Mikel De RSS

    Date Field and Load Expression

    Mikel De



      I have some problems with the data preparation. Normally, when I load an excel file, Qlik Sense lets me define that a particular column contains dates like this:




      However, I have just loaded an excel file that contains four sheets (data for Jan, Feb, Mar, and Apr and all of them with the exact same structure and column names) and this option is not available:




      What could be the problem?



      My second question is if there is any way to create a general Load Expression using the Data Load Editor. I would like to change the column names of all four sheets and if it is possible this expression should also work for the next files I'm about to load soon (May and Jun).