LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  X-ref Node Outputs 200,000+ when input is only in1=19,000 and in2=11,000

    Employee
    Posted 03-15-2018 11:28

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Brad Brezinski

    Hi, I think I'm may be min-understanding something. I have a x-ref node in1 = 19,000 and in2 = 11,000. I only want the records where the circuit id is present in both lists. I get an output that returns 159,000+ records, when using a x-ref, join-inner, and xref node. Which node should we be using here? Thanks!


  • 2.  RE: X-ref Node Outputs 200,000+ when input is only in1=19,000 and in2=11,000

    Employee
    Posted 03-15-2018 11:52

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    You are getting what is called a Cartesian Join.. more records out than in, because many of the data values are duplicated. Use "Remove duplicates" to either one (or both) of the input pins and you'll end up with a result more like what you want.

    Or use Lookup with the Duplicate Behavior set to Ignore.

    FYI... if your data has NULLs in it.. that is often the source for the duplicates. You might also try removing the NULLs first.


  • 3.  RE: X-ref Node Outputs 200,000+ when input is only in1=19,000 and in2=11,000

    Employee
    Posted 03-15-2018 12:01

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Brad Brezinski

    Thanks Stony, I forgot to removed the duplicates from one of my inputs! Sigh, Thanks Stony! Brad