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.