Compare Data Set to a list of Keywords and find (contains) matches
Forums
Hi. I am working on a project to compare a data set DATATABLE with customer names (CUSTNAME field) against a separate table KEYWORDS with 1000 words. I want to either filter, or extract/return, results if there is a the CUSTNAME field contains any word in KEYWORDS.
Is there a way to do this? I'm thinking probably a loop to go through each of the data elements in the key words table and then to do a "contains" comparison with isini or something? Just wanted to see if there was a way, or code available, to do this. Thanks!
If the words are not an exact
If the words are not an exact match you can also use the fuzzy match option. Here is a video to help you out on this:
I don't see the need to use a
I don't see the need to use a script. Does IDEA function join (db1: DATATABLE; db2: KEYWORDS; compare: field CUSTNAME & field WORDS?; all data from db1) not solve your problem?