Adding date field creates duplicate rows with null date values

[Anonymous]

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

[Gysbert_Wassenaar]

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

[vinieme12]

Can you post a screenshot of your Data Model?

are you doing any Joins?

[Anonymous]

Thanks for the responses.

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

Michael