Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-01-11 11:26 AM

ORACLE: CONVERT NUMBER(17) TO STRING

Hello!

I have troubles to work with data stored as number(17) in oracle db. After loading data into app, i see a scientific representation of the number, which i can't handle.

Definition in oracle db:

1.png

View of data in oracle db with Oracle SQL Developer:

2.png

View of data in Qlik Sense data manager after load:

3.png

How can i convert this scientific number to normal number or string, as represented in Oracle SQL Developer?

Martin

Labels (1)
Labels
2,090 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-01-15 05:41 AM
Author

Hello!

SOLVED: it was only a problem representing the number. So it was not possible as expected to convert number2string implicit and get first 4 chars for year.

Now i cut milliseconds from timestamp first by dividing number / 1000 on load script.

LOAD VCE_NDATE_CREATED / 1000 as VCE_NDATE_CREATED, ...

Martin

1,892 Views
0 Likes