UnMatched Records - Dates casing other columns to get pushed to other columns

Feb 11, 2015 at 2:15 PM
Hi,

We have noticed that where we have dates (e.g. 2014-02-11) the column values in the subsequent columns get pushed out to the next column.

For example, when below input to DQS goes to the unmatched table..

DATE OF INCORPORATION RATING NET WORTH
2011-01-01 A1 NULL
NULL A2 NULL

It looks like below in the unmatched table (Rating in first row ends up in Net Worth)
DATE OF INCORPORATION RATING NET WORTH
2011-01-01 A1
NULL A2 NULL

The data type for the Date Of Incorporation is date.

I do not have this problem on the records written to the Matched table.

Anyone know why this is happening or what is the cause? Is it a defect?

Any steer on this is appreciated.

Thanks.
Coordinator
Mar 8, 2015 at 9:07 PM
Hi,

can you send me more detailed data as well as your DQS KB or screenshots of your matching policy?

Cheers,

Tillmann
Coordinator
Mar 8, 2015 at 9:08 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Mar 26, 2015 at 9:16 AM
Hi Tillmann,

Thanks for coming back to me.

I have attached two screen shots; one of the mappings and one of the matching policy.

I have also attached an Excel workbook which is the source data for DQS.

Let me know if you need additional details.

Thanks,
Clive.