Data Formatting issue while storing the data into QVD

[nagarajuecs]

Hi Team,

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

Date:

2018-02-03T10:22

2018-03-04

2018-04-05T05:00

2018-06-07

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).

Date:

2018-02-03T10:22

2018-03-04T00:00

2018-04-05T05:00

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.

Regards,

Nagaraju

[shiveshsingh]

Try this while loading in script in qlikview

Text(Date) as Date

[pradosh_thakur]

We have a variables defined in Qlik which is creating the issue for you. You have two option to tackle this.

1:  Change the variable defination

2: Use text(field) as sugested

[nagarajuecs]

We used text() to handle this issue. But, we have multiple date columns and in this case, we have to apply the same function across. Do you know the reason why it's doing the conversion in QVD?

[marcus_sommer]

If you want to have multiple formattings for the fieldvalues within a field you need to load them with the formattings, maybe with something like:

alt(date(date#(Field), 'format'), 'format'), timestamp(timestamp#(Field), 'format'), 'format'))

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.

- Marcus