topic Re: Adding date field creates duplicate rows with null date values in QlikView

Adding date field creates duplicate rows with null date values

Anonymous — Fri, 31 Mar 2017 21:10:26 GMT

Hey Everyone,

When I add a date or time field to my data set, each row is duplicated -- with one row having the correct date/time field and the other row having a blank date/time field. I've done some debugging myself buy cannot find why row ares duplicating. The raw data do NOT have any blank date/time values.

The screenshots below show what my data set looks like before and after adding the date/time fields. Unfortunately I cannot attach the QVW document as an example.

Has anybody come across this before or know of a solution?

Thanks in advance.

Michael

Prior to adding date/time

After adding date/time

Re: Adding date field creates duplicate rows with null date values

Gysbert_Wassenaar — Sat, 01 Apr 2017 07:19:22 GMT

It looks like there's a value in Due Date rm that consists of an empty string or a string of spaces. Since I have no idea what data you're loading and how you do that I can't help you further.

Try to create an example that demonstrates the problem. Perhaps this document helps: Preparing examples for Upload - Reduction and Data Scrambling

Re: Adding date field creates duplicate rows with null date values

vinieme12 — Sat, 01 Apr 2017 08:24:28 GMT

Can you post a screenshot of your Data Model?

are you doing any Joins?

Re: Adding date field creates duplicate rows with null date values

Anonymous — Sun, 02 Apr 2017 21:13:28 GMT

Thanks for the responses.

Here is a simplified qvw file. Hopefully it will explain the situation better.

Michael