Question

Feature contains elements from two lists

jdh
Rank
Badge +22
  • jdh Contributor
  • Contributor
  • 1961 replies

I have a set of lists

 

 

_option1{0}=A

 

_option1{1}=B

 

_option1{1}=C

 

 

_option2{0} = X

 

_option2{0} = Y

 

_option2{0} = Z

 

 

and values

feature 1

 

_list{0} = A3

 

_list{1} = 7B2

 

 

feature 2

 

_list{0} = 4X

 

 

feature 3

 

_list{0} = C2

 

_list{1} = 3Z

 

 

 

I need to identify only those features that whose list elements contain items from both _option1{} and _option2{} .

 

 

In the above example, that would be feature 3.

 

 

The data list values are not an exact match to the values in the option lists, just contain them.

 

There can be any number of elements in the data list.

 

The options are the same for every feature.

 

 

4 replies

daveatsafe
Rank
Userlevel 2
Badge +17

Hi @jdh,

You can use a combination of ListConcatenator and AttributeCreator to concatenate the _option lists into regex expressions (ie. [XYZ]). Then use two StringSearchers to search _list by those expressions. I am attaching a workspace to illustrate.

searchlist.fmw

ebygomm
Rank
Userlevel 1
Badge +21

Create two attributes in python that are populated depending on whether there is a match between each list, then you can test for where match_list1 or match_list2 are both true.

import fme
import fmeobjects

def processFeature(feature):
    match1 = ['A','B','C']
    match2 = ['X','Y','Z']
    list = feature.getAttribute('_list{}')

    for x in list:
        if any(y in x for y in match1):
            feature.setAttribute('match_list1','true')
        if any (y in x for y in match2):
            feature.setAttribute('match_list2','true')
        

 

jdh
Rank
Badge +22

Hi @jdh,

You can use a combination of ListConcatenator and AttributeCreator to concatenate the _option lists into regex expressions (ie. [XYZ]). Then use two StringSearchers to search _list by those expressions. I am attaching a workspace to illustrate.

searchlist.fmw

Unfortunately the actual codes are not single characters, so I end up with many false positives.

jdh
Rank
Badge +22

Create two attributes in python that are populated depending on whether there is a match between each list, then you can test for where match_list1 or match_list2 are both true.

import fme
import fmeobjects

def processFeature(feature):
    match1 = ['A','B','C']
    match2 = ['X','Y','Z']
    list = feature.getAttribute('_list{}')

    for x in list:
        if any(y in x for y in match1):
            feature.setAttribute('match_list1','true')
        if any (y in x for y in match2):
            feature.setAttribute('match_list2','true')
        

 

I had tried the 'any'  but got lost in triple for loops,  running two separate searches and testing for True and True  is the piece I was missing.

Reply


Community Stats

28,707
Posts
109,479
Replies
36,552
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.