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?
Please sign in to leave a comment.