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.  How to make X Ref node NOT case sensitive?

    Employee
    Posted 01-13-2017 11:31

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

    Originally posted by: jessielee

    Hi,

    I am trying to do some gap analysis and noticed that the x-ref node is case sensitive. How can I make this not case sensitive so that it's going to consider "EXAMPLE" and "example" the same thing?

    Thank you!


  • 2.  RE: How to make X Ref node NOT case sensitive?

    Employee
    Posted 01-13-2017 11:42

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

    Originally posted by: stonysmith

    The operands to the Join and XREF node allow expressions, not just field names.

    Instead of using only the field name, use the uppercase function on the data.
    LeftInputKey: toUpper(myfieldname)
    RightInputKey: toUpper(myfieldname)

    Or use toLower() .. either one would work

    Let's say you have a date field that is formatted as a string: 2017-01-13
    you could for example use:
    LeftInputKey: left(mydatefield,4)
    RightInputKey: left(mydatefield,4)

    and this would match on just the YEAR portion of the field (first four characters)