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

Follow

Tony Schullo

• July 05, 2017 13:41

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

0

• 

  Gido

  • July 05, 2017 13:56

  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

  Comment actions Permalink
• 

  Tony Schullo

  • July 05, 2017 14:12

  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

  Comment actions Permalink

Please sign in to leave a comment.