topic Re: Data Formatting issue while storing the data into QVD in App Development

Data Formatting issue while storing the data into QVD

nagarajuecs — Sat, 16 Nov 2024 06:32:04 GMT

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

Re: Data Formatting issue while storing the data into QVD

shiveshsingh — Thu, 21 Feb 2019 08:49:32 GMT

Try this while loading in script in qlikview

Text(Date) as Date

Re: Data Formatting issue while storing the data into QVD

pradosh_thakur — Thu, 21 Feb 2019 09:02:27 GMT

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

Re: Data Formatting issue while storing the data into QVD

nagarajuecs — Thu, 21 Feb 2019 10:41:45 GMT

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?

Re: Data Formatting issue while storing the data into QVD

marcus_sommer — Thu, 21 Feb 2019 13:41:04 GMT

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