Data Formatting issue while storing the data into QVD
We are facing an issue with the data formatting while storing this data to QVD. We need the exact data whatever we have in the database. for example, the date column has data like
When you observe the above data, it has different formats and the same data should be stored in QVD. But, when we load this data to QVD, it's converted to single format based on the first value and the output data stored in QVD as below (Appended timestamp to it).
2018-06-07T00:00 which is not expected.
Currently, we handled this issue by using text(Date) and we have many date columns. Similarly, we have to handle this for different variables. Why Qlik can't store this as it is?
I feel it's an issue in the Qlik. Feel free to add your comments.
Further it might be useful to split such timestamp into a date- and a time-field and just to add them together again where it's really needed. Such an approach would simplify some tasks and could save a significantly amount of resources, see: The-Importance-Of-Being-Distinct.