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.

Node Help - Joins with string fields

Follow
Avatar
Infogix Support
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
0

Comments

1 comment

Sort by Date Votes
  • Avatar
    Infogix Support
    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
    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post