We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

I want to find records that uniquely match from given datasets

Comments

3 comments

  • Avatar
    Adrian Williams

    The node is operating correctly as there are multiple instances of the value '1' in the Left data set. Records are processed one at a time and the result of the join for the current input record are processed and written to the results set at that time.

    The correlation nodes do not offer an option to post-process the join results to identify distinct value combinations. It would be necessary to use a separate node to obtain the disinct combinations.

    0
    Comment actions Permalink
  • Avatar
    Ishwari Mahajan

    Dear Adrian,

    Could you please provide the code for this

    Thanks :)

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    There is no code as such, the logic was built by configuring code-free nodes. An example data flow is attached.

    Note, in the example the field in Dataset1 is being renamed just to clarify the operation of the node.

     

     

    Attached files

    Merge_Node_Join_Distinct_Example_342 - 27 Aug 2020.lna

     

    0
    Comment actions Permalink

Please sign in to leave a comment.