Data360 DQ+

 View Only
Back to discussions
Expand all | Collapse all

How to run a test on two fields combined equalling the same as another fields form a different source system

  • 1.  How to run a test on two fields combined equalling the same as another fields form a different source system

    Posted 11-17-2021 07:10

    The DQ rule is

    Forename + Surname in POL Source System 1 must equal Full Name in AD Source System 2

    I need to combine the two fields in Source System 1 first with a space between the name and then compare it to the filed in source system 2 which is the full name?

     

    How can I go about this using the tools in infogix 

    Or Is regex better?

    Thank you in advance

     

    Attached files

    screen shots for rule.docx

     



  • 2.  RE: How to run a test on two fields combined equalling the same as another fields form a different source system

    Employee
    Posted 11-18-2021 13:17

    Hi Stephen,

    Reviewing the attached document and requirements, it may be worthwhile to explore a simple concatenate of the data store node as a derived field ( as opposed to a join ). For example :

    Looking at the LHS, the concatenate field is derived ( this is created manually, not pulled from the data ) :

    Looking at the RHS :

    Once this is in place, a recon node ( labeled "recon check" within photo ) will check both the LHS and RHS :

    Matthew Kennedy



  • 3.  RE: How to run a test on two fields combined equalling the same as another fields form a different source system

    Employee
    Posted 11-18-2021 13:19

    When building the derived field, you would do so by including the following formula ( space is included within the output this way ) :

    Matthew Kennedy