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.  Node Help - Joins with string fields

    Employee
    Posted 09-08-2017 15:36

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

    Originally posted by: Brad Brezinski

    I have two data sets. One data set is of office location codes. The second data set is of comment strings that include multiple references to the office location codes from the first data set. I would like to know which office location codes are mentioned in any one of the comment string in the second data set. Can I do this with a right join in some way? Or would I have to incorporate an array in some way? Thanks, Brad


  • 2.  RE: Node Help - Joins with string fields

    Employee
    Posted 09-14-2017 06:56

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

    Originally posted by: awilliams1024

    Hi Brad,

    here is one method of identifying which location codes are mentioned in the comment string values. The data flow outputs the mentioned location codes as a comma-separated list of strings. It then also expands this list to produce a record for each location mentioned.

    Find_Location_Code_Mentions_v2.brg

    Regards,
    Adrian