Searching for matches (text CONTAINS) against a list of possible values

1 follower
0
Avatar

I have a list of account numbers that I want to search for any reference of in a series of columns.

Ideally, I would concatenate all the columns together and iterate through each member of the list looking for matches.

I accomplish this in QlikView by mapping any occurrence of the list to MATCHFOUND and then flagging any records where MATCHFOUND is found in my string.  How can I accomplish this in Datameer?

 

Thanks,

 

Tony

Tony Schullo

2 comments

  • Avatar
    Gido

    Hello Tony,

    To "concatenate" all the columns together and iterate through each member of the list looking for matches you could use the following approach:

    Create a LIST

    LIST(#Col1; #Col2; #Col3; #Col4; #Col5)

    and looking up for matches via

    CONTAINS(#List; #AccountNumbers)
    0
  • Avatar
    Tony Schullo

    Thanks Gido! So do I need to make my Account numbers a LIST as well? The list will vary and most likely be in a reference table.

    0
Please sign in to leave a comment.