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

    Date Field and Load Expression

    Mikel De

      Hello!

       

      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:

       

      Capture.PNG

       

      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:

       

      Capture2.PNG

       

      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).

       

      Thanks!

       

      Best,

      Mikel