topic Re: Max Character per field in QlikView

Max Character per field

Mon, 10 Feb 2014 04:05:03 GMT

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.

Re: Max Character per field

senpradip007 — Mon, 10 Feb 2014 04:51:33 GMT

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.

Re: Max Character per field

MayilVahanan — Mon, 10 Feb 2014 05:13:21 GMT

Try using with text() function

Load text(accountno) as accountno,

...

from SampleDatabase.xlsx;

Re: Max Character per field

qlikpahadi07 — Mon, 10 Feb 2014 05:16:25 GMT

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 ....

Re: Max Character per field

Mon, 10 Feb 2014 05:58:25 GMT

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..

Re: Max Character per field

qlikpahadi07 — Mon, 10 Feb 2014 06:14:54 GMT

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.

Re: Max Character per field

Mon, 10 Feb 2014 06:35:05 GMT

Good info. take note on that.

Hafidz

Tiada yg menghalang