Loading problem Excel file

[fatihsahin]

Hi community,

I have a strage Problem during loading from an Excel file:

I have one field "category":

In following structure:

Category

"1.ABC"

"2.BCD"

"3.ABD & BCD"

Now after the reload I have only the last part of the third value --> in specific only BCD instead of "3.ABD & BCD"

I dont have a clue how this Comes - in the Excel file it is correct.

Any idea?

Thanks

[sunny_talwar]

Can you make a dummy Excel with the one row containing $ sign and share the script you would use to load the file into QlikView? This way we might be able to see what is going wrong.

[sunny_talwar]

or can you try to run this qvw file on your computer and sharing a image of the table box object just like how I did in my previous post?

[nizamsha]

Hi

I checked this using inline its working fine

Category

"1.ABC"

"2.BCD"

"3.ABD & BCD"

you might have a problem in excel file check the excel properly how its sit if still u cant identify upload the excel so others have a look at it and they will try to give the solution

[fatihsahin]

Cant upload the original file and if I copy & paste into another Excel the Problem do not anymore occur.

Anyhow I have to fix this Problem with that file.

I guess it something about the Excel - its a xlsx Format.

[Anonymous]

hi fatih,

May be It is the relation of the data fields you have in the file.

please check if the other values in the row for value "3.ABD & BCD" are loaded properly

[nizamsha]

Just upload only the 3 record how its sit in ur excel

[Anonymous]

Hi,

Please Share the sample Excel file .

Thanks,

Bunny