We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

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

Comments

2 comments

  • Avatar
    Matthew Kennedy

    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

    0
    Comment actions Permalink
  • Avatar
    Matthew Kennedy

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

    Matthew Kennedy

    0
    Comment actions Permalink

Please sign in to leave a comment.