Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
evan_kurowski
Specialist
Specialist

Oracle and Text values which toggle between numeric and text interpretation

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.

1 Reply
Anonymous
Not applicable

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