Solved

Search list for values on multiple attributes

tva
Rank
Badge +10
  • tva Contributor
  • Contributor
  • 28 replies

Hi,

The listsearcher makes it possible to search in a list for a certain value on 1 Attribute.

Is it possible to do this (without listexploder) to search in a list for values on different attributes?

list example:

_names{0}.LC = Arabic

_names{0}.NA = Latin

_names{0}.PN = true

_names{1}.LC = Arabic

_names{1}.NA = Arabic

_names{1}.PN = true

 

I want to search in names list where PN = true & NA <> Latin and get that indexback. In this case it would be 1

If it's not possible in FME, how would I do this via python in FME then?

icon

Best answer by david_r 8 March 2023, 11:16

View original

5 replies

david_r
Rank
Userlevel 4

For Python, do something like:

lc_list = feature.getAttribute('_names{}.LC') or []
na_list = feature.getAttribute('_names{}.NA') or []
pn_list = feature.getAttribute('_names{}.PN') or []
items = zip(lc_list, na_list, pn_list)
 
feature.setAttribute('found_index', -1)
for index, item in enumerate(items):
    if item[2] == 'true' and item[1] != 'Latin':
        feature.setAttribute('found_index', index)
        break

This will return the first found index in the attribute 'found_index'. The value will be -1 if not found. Depending on your testing it may be that you have to modify line 8 to read:

if item[2] == True and item[1] != 'Latin':

 

ebygomm
Rank
Userlevel 1
Badge +10

Do you mean PN = true & LC <> Latin ? As this is true for both examples in your list

tva
Rank
Badge +10

Do you mean PN = true & LC <> Latin ? As this is true for both examples in your list

Thanks for pointing this out. Adapted the question

ebygomm
Rank
Userlevel 1
Badge +10

Thanks for pointing this out. Adapted the question

Then this line in the code just needs changing

if item[2] == 'true' and item[0] != 'Latin':

to

if item[2] == 'true' and item[1] != 'Latin':

 

david_r
Rank
Userlevel 4

Thanks for pointing this out. Adapted the question

Thanks, fixed my original answer accordingly.

Reply


Community Stats

28,661
Posts
109,324
Replies
36,528
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.