Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kalyan79
New Contributor

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
Honored Contributor II

Re: problem while loading data from Excel

Does that columns have a text or are blank ?

_armoco_
Contributor II

Re: problem while loading data from Excel

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

Community Browser