7 Replies Latest reply: Apr 1, 2015 7:36 AM by Rodrigue Saade RSS

    Read Data from excel with merged columns

    Rodrigue Saade

      Hi,

       

      looking to the image below, you can see a screenshot of an excel table, having three columns merged under 1 column which is a date range. How can i read this file into Qlikview, to retrieve in the end three fields: the Name, the date ranges and the values (NC, DNP...)?

       

       

      download.png

       

      Thank you..