3 Replies Latest reply: Feb 6, 2015 8:08 AM by Rahul Basu RSS

    How to load only some data from an excel file

      LOAD

          FY.YEAR as "FY",

      //     "MONTH" as "Month",

        MonthName("Begin of Month") as Month,

          Quarter as Quarter,

      FROM [lib://Desktop/Tequila & Cream H1 2014-15.xlsx]

      (ooxml, embedded labels, table is Sheet1);

      WHERE Match(FY.YEAR,'2013-14');

       

      I have a file with a lot to data. I only want data relating to FY 2013-14. Its stored as a text field in the excel sheet. I tried using FY instead of FY.YEAR, but that didn't work either.