Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!