I have a column ,say, ID having high precision sixteen digit number 1999999999999999 in a very large data set .
1. Firstly I would load the large data set into a qlikview table,say,TEST: and then store it into a qvd ,say,sample_temp.qvd. This loads from a oracle DB using select statement.
2. Next,I would drop the qlikview internal table TEST after loading and storing in the QVD. When I see the ID column here (before dropping the qlikview table) the precision stays solid.
3.Now, as said above,after dropping the TEST table , I use a qlikview query having transformations,joins and where clause to store them in to a another qlikview internal table TEST1 and in turn to a QVD say,sample.qvd.
Here the actual problem surfaces. The ID column is converted into an exponential number like 1.99999999999999e+15
SELECT ID,AMOUNT FROM SALES :
STORE TEST INTO SAMPLE_TEMP.QVD;
DROP TABLE TEST:
(Precision stays solid until here)
LOAD ID ,AMOUNT,<SOME TRANSFORMATION ON COLS> FROM SAMPLE_TEMP.QVD(qvd);
When you put table box on TEST1, I lose the precision on ID column and it shows like 1.99999999999999e+15
Why is this happening ? Am I missing something here ?