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

[lironbaram]

how exactly is your script written

because  on a simple load i can't reproduce your error

[fatihsahin]

No Transformation - nothing. Just straight loading.

[petter]

It might be that QlikView interprets this a bit too much ... the values from Excel. I am not able to reproduce it.

But you could try to do this in your load - as the Text() function will effectively prevent Excel from doing the possibly error prone interpretation:

LOAD

     Text( Category ) AS Category

FROM

     yourExcelFile.xls (ooxml .... ) ;

[fatihsahin]

Hi Petter,

thanks for the tip but I have already tried "text" but no success.

The only difference to the rest of the values is , that this value has a "&" sign but really not sure what the Problem here is.

[sunny_talwar]

Like the other mentioned, I did not have any issue loading the complete value ("3.ABD & BCD") with a simple load statement. This is what I used:

Table:

LOAD Category

FROM

[Community_186332.xlsx]

(ooxml, embedded labels, table is Sheet1);

I don't know if that is going to help, but try creating another qvw file and re- add this particular Excel file using Table Files... and see if this problem persist for you. 

[petter]

Then it seems like your load have the field number 1 mispelled. QlikView is case sensitive when it comes to field and column names. And it seems that you get an empty string ...

[petter]

Could you please share the part of the load script where you have your load statement and possible attach the Excel-file or the first few rows...

[fatihsahin]

I have now observed that this Problem always occurs if the value contains "&".

Whenever a "&" occurs it is only taking the part after the "&".

Could someone help based on that help?

Would it help to replace this sign with chr() ?

Regards

[petter]

You need to share the script and a sample Excel file with us...