Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with insertion from excel

Hello !

I have a weird problem. I have this table in excel

DataDimension1Dimension 10

Dimension 20

01/01/201111121
01/02/201121222
01/03/201131323
01/04/201141424
01/05/201151525

And when I try to insert it, it gives me that :

table.bmp

Please help me... It makes me crazy.

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Problem with insertion from excel

I am unable to reproduce the problem. I tried to load your data using the script

LOAD Data,

     Dimension1,

     [Dimension 10],

     [Dimension 20]

FROM

C:\Users\Kris\Desktop\Test17.xlsx

(ooxml, embedded labels);

and it worked correctly.

2 Replies
nagaiank
Valued Contributor III

Re: Problem with insertion from excel

I am unable to reproduce the problem. I tried to load your data using the script

LOAD Data,

     Dimension1,

     [Dimension 10],

     [Dimension 20]

FROM

C:\Users\Kris\Desktop\Test17.xlsx

(ooxml, embedded labels);

and it worked correctly.

Not applicable

Problem with insertion from excel

Thank you