topic Re: Data loading changes data in column to "?" in QlikView

Data loading changes data in column to "?"

Sat, 30 May 2015 21:07:41 GMT

I have a strange situation. I am loading 2 tables with 1 common key. For some reason in the 2nd table loaded from an .xlsx file the key gets changed to "?" after I load. This only happens when that column is picked up by Qlikview as being a key to link the 2 tables.

Any advise on what may be happening here?

Thanks

Amit

Re: Data loading changes data in column to "?"

Sat, 30 May 2015 21:17:02 GMT

I used a .csv format and that fixed it. Why wouldn't the .xlsx file work????

Re: Data loading changes data in column to "?"

stabben23 — Sat, 30 May 2015 21:34:10 GMT

the ? tells you that the key has different format, no match.

Re: Data loading changes data in column to "?"

awhitfield — Mon, 01 Jun 2015 10:34:06 GMT

Hi Amit,

it would be helpful if you could upload the actual excel file and the relevant section from your load script.

HTH Andy