LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: danhowe

Hi,

I have a list of strings in a "Page Name" field in a set of data eg

page name 1
page name 2
page name 3


and I have a list of strings to search for in file which I have imported. eg
pa
page
name 1


I'd like to use the list strings from the file import to do a contains search on each record in the Page Name field and create a new field with a value of true/false depending if any of the search strings are contained in the Page Name field.

I'm unsure of how to approach this problem in Lavastorm. I can see how I could do this using a list coded into a filter node, but ideally I want to use the output of the file import node as the list of values to search for as this list may change over time.

Hoping someone can point me in the right direction.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

I believe the attached example will give you the results you want. It is dynamic, so if you want to add new search values you just add them to the Search List input. I have this list as a static data node, but it could be any input data (file, db query, etc). I used the strFindI function to do the matching, which is case insensitive. If you want to insure matching by case is enforced you would need to change that to the strFind function.

I'm sure there are other ways that might be more efficient, but this one works.
Attachments:
MatchByList.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: danhowe

Hi Larry,

Thanks for your reply and example graph. This works well and has pointed me in the right direction.

Cheers,
Dan.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: danhowe

In case it is useful to anyone else, I've attached an example graph of my end approach using the input from Larry.
Attachments:
Contains Look-up.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Nice example Dan. Thanks for sharing!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Oh, neat! And here's one more variation. I basically took Dan's example and removed the Look Up's and used Join Inner's instead. This allows us to not have to create the same include/exclude columns for each record.
Attachments:
MatchByList_v2.brg