Oracle and Text values which toggle between numeric and text interpretation

evan_kurowski — Tue, 15 Apr 2014 19:31:57 GMT

Does anyone know anything about why certain values when read in from Oracle or from a .txt file seem to have the Dual() characteristics, even though their display value is reading in alphabetic characters?

For example, when reading in the values below from a .txt file they interpret as Numeric. The only way I can get them to interpret as text is by explicitly forcing them to text.

071D12

453D04

379D68

5430E5

Except it is only happening at my current client's environment. If I attempt the same excercise at home on my laptop, the values read in as a text value. That seems to indicate that the numeric interpretation is a toggle-able behavior and one I can only duplicate in the client environment.

So is my client developing some new data strain that is impossible for QlikView to read? Or is there some interpretation module/setting that can turn this on or off?

Thoughts appreciated.

Re: Oracle and Text values which toggle between numeric and text interpretation

Anonymous — Tue, 15 Apr 2014 19:33:04 GMT

Hello Qlik Community Members- this discussion was posted previously but accidentally deleted we are recreating the thread. Any helpful answers are welcomed!

topic Re: Oracle and Text values which toggle between numeric and text interpretation in QlikView

Oracle and Text values which toggle between numeric and text interpretation

Re: Oracle and Text values which toggle between numeric and text interpretation