Max Character per field

[#1]

I'm facing issue on uploading data since Qlikview gave a character which cannot be read between other database. Appreciate if you could

look into the attachment (with screenshot) for your understanding.

Anyone in this community help is highly required since I'm using it for my daily works.

[senpradip007]

Hi.

As per my understanding by going through your doc and excel file you can't upload 17 character AC No. But when I've tried to load the data from the sample excel file its working fine.

PFA.

[MayilVahanan]

HI

Try using with text() function

Load text(accountno) as accountno,

...

from SampleDatabase.xlsx;

[qlikpahadi07]

Hi Mohd,

I am not sure what exactly you facing the problem, I have simple pulled the attached Sample and here is the screen shot which seems okay ....

[#5]

Hi Sir,

I'm facing this issue when the database is .xlsx. I've just tried to uplaod the same data but in .csv format & the result its ok. Is the format of the file might be the issue or the pc itself?

Hafidz

Tiada yg menghalang..

[qlikpahadi07]

Hi,

well I haven't change any thing from my end  the attached file sample Database.xlsx  which you attached I have simple pulled data which looks okay with me.

As you said .csv worked fine with you then it is obvious the format issue you can upgrade your office to 2010 which I am using currently might help.

[#7]

Good info. take note on that.

Hafidz

Tiada yg menghalang