Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

problem while loading data from Excel

Hi All,

I’m facing problem while loading data from Excel.

I loaded data for 2 days (Same data). Why Qlik (View And Sense) giving Different names like F19,F20,F21,F22  and S,T,U,V

For same data.

Ex: Sample1:  F19,F20,F21,F22

Sample1.png

Sample2: S,T,U,V

Sample2.png

Thanks,

Kalli

Message was edited by: Kalyan P

2 Replies
agigliotti

Does that columns have a text or are blank ?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
_armoco_
Partner - Creator II
Partner - Creator II

Hi Kalyan,

Those are blank columns in excel that are being picked up by QlikView.

You can remove it by clicking the 'X' button

OR

Simply load and remove/comment those from the editor

OR

Remove it from excel itself

Save the excel file and load again

Regards,

Arjun