0 Replies Latest reply: May 24, 2017 5:20 AM by Vikram Sridharan RSS

    Issue with Adding Data in Excel Format

    Vikram Sridharan

      Hi All,

       

      I am new to Qlik Sense and just starting out with its functionalities. I receive a large amount of data as Excel files and I save from my outlook to a folder without opening the file. When I open add data in Qlik Sense, and the load table opens, only 4 columns are available while the original file has 20 fields.

      If I open the excel file, save it and add data in qlik sense again, now I can see all 20 columns. Also, if i save as csv, all fields are visible. Please let me know what is causing this issue and how do I resolve it? Our ETL at data source cannot output csv format.

       

      Appreciate any help! Thank you.

       

      Vikram