Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
Partner - Champion
Partner - Champion

Does that columns have a text or are blank ?

_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