I recently stumbled on a problem with pulling data from Oracle and Qlikview interpretation of the Client Code.
If I load our client table which has a unique key of client code I have matching issues to the client name.
The client codes that are problematic are (that I have found so far) below.
02D09
02D07
03D09
One observation seems to be that in a list box the above are aligned right along with other wholly numeric client codes, whereas text based codes are aligned left.
My starting guess is that the D is being treat as numeric possibly hexadecimal ?
I have stripped back my load to look at the client code and client name only.
I have a linked MS Access table pointing at the Client Table and this issue is not replicated.
Totally stumped to be honest, so would appreciate any guidance available.
I should have elaborated slightly - this is only a problem on our Qlikview Server not on my local Dev copy. I am more drawn to an Oracle Environmental issue as I just fired up the old Qlikview Server which is running Oracle 10.2 new one is Oracle 11 and same load script works fine on old server whereas new one is giving the issue?
I tried the text which works fine on one table but when I start joining with other tables the joins do not work.
I'll have a go at the text option a little more with a view to possibly concatenating an X at the start (to be sure).
Can anyone tell the step by step procedure for connecting qlikview with Oracle 10g.Also tell me what are all the things (like driver )should need to intall on system for data connetivity? My data is in the format of .dmp file.How to retrive the such data?
.png "Former Employee"){kind=icon}