Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you post a screenshot of your Data Model?
are you doing any Joins?
Thanks for the responses.
Here is a simplified qvw file. Hopefully it will explain the situation better.
Michael