topic Re: Surviving Record Identification Node Dataflux 2.8 - bring in values from other records in SAS Data Management

Surviving Record Identification Node Dataflux 2.8 - bring in values from other records

beamer108 — Wed, 31 Mar 2021 17:58:20 GMT

Hi - new to match code, cluster node and surviving record identification nodes. Once I have successfully identified which record is the surviving record, I want to look for fields in the duplicate records and populate the survivor record with any missing data.

Example - My survivor has address, first name, last name but is missing telephone number, middle initial and title. The matching records have this information populated, I want to bring fill the fields into the survivor record where it was previously null.

I find documentation within the DF application but its highlevel. I'm looking documentation that walks through in detail how to set up the survivor node, some examples to review or even some instruction via the community.

Thank you in advance.

Re: Surviving Record Identification Node Dataflux 2.8 - bring in values from other records

audrey — Thu, 01 Apr 2021 11:14:28 GMT

Hi,

in the Surviving Record Identification node, there is a "Field Rules" button which will let you create your own rules to define what field your surviving record will be composed of. You can create one saying for example "Name <> empty string".

Does this help?

Audrey

Re: Surviving Record Identification Node Dataflux 2.8 - bring in values from other records

beamer108 — Thu, 01 Apr 2021 11:51:05 GMT

This is an example of what I have for the middle name:

and this is what I get back:

The row showing true is my surviving record - I would like the 'R' in middle name from the row above it to appear in the surviving record row.

Re: Surviving Record Identification Node Dataflux 2.8 - bring in values from other records

audrey — Thu, 01 Apr 2021 11:59:04 GMT

The Middle Name doesn't seem Null but blank. What if you try with Middle Name <> ""?

Re: Surviving Record Identification Node Dataflux 2.8 - bring in values from other records

beamer108 — Thu, 01 Apr 2021 12:31:44 GMT

Thanks for continuing to try to help me. I just tried this:

and I get the same results.

For this job I have multiple fields that I'm referencing in the Field Rules - maybe I have that set up incorrectly.

I have each rule set up separately like this:

Should I have them all in one condition??

Re: Surviving Record Identification Node Dataflux 2.8 - bring in values from other records

beamer108 — Thu, 01 Apr 2021 13:05:02 GMT

I think I have it. If I use 'longest value' for the middle name it works. I tested out other fields and if I use isnot null, the field does not pull in. If I use longest value - the fields pull in.

I don't know that I understand why, other then maybe blanks are treated differently then nulls.

Thanks for giving me some options to test out - hopefully this will do the trick.