Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikram_sridhara
New Contributor

Issue with Adding Data in Excel Format

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

Tags (2)