Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

0 Replies