3 Replies Latest reply: May 29, 2017 10:11 AM by Stefan Wühl RSS

    QlikSense isn't fetching filename from Xlsx format

    Hari Prasath

      Hi All,

       

      I am unable to fetch filename from xlsx files in QlikSense. but it fetches the filename form xls file.

      below is the script which i have used:

      LOAD
          CIN,
          COMPANY_NAME,
          COMPANY_CLASS,
          COMPANY_CATEGORY,
          COMPANY_SUBCAT,
          COMPANY_STATUS,
          DATE_OF_REGISTRATION,
          REGISTERED_STATE,
          "Authorized Capital  (Rs.)",
          "PAIDUP_CAPITAL (RS.)",
          PRINCIPAL_BUSINESS_ACTIVITY_CODE,
          REGISTERED_OFFICE_ADDRESS,
          EMAIL_ID,
          "LATEST ANNUAL REPORT FILING FY END DATE",
          "LATEST BALANCE SHEET FILING FY END DATE",
          FileName() as File_Name
      FROM [lib://Company Master Data/Andaman_Nicobar_Islands_2016.xls]
      (biff, embedded labels, table is Sheet2$);
      

       

       

      Please help!