Hello everyone,
I try to solve problem with numbers and values. In my project, I manage SQL select count via SQL Executor, so the result of query could be for example number 5. But what I need in second step, I have to create list with minimal value 0 and maximum value (result of query) 5. So list will contain following values 0,1,2,3,4 and 5.
Any tips please?
Thank You so much!
Lubo
The "obvious" solution would be to use a Cloner with your query result as number of copies, followed by a ListBuilder.
You can also accomplish the same thing using Python, it is probably also more efficient, performance-wise:
import fmeobjects
def generate_list(feature):
items_to_create = int(feature.getAttribute('count') or 0) + 1
items = r''] * items_to_create
feature.setAttribute('list{}', items)You need to supply an attribute "count" and it will return a list called "list{}" with count+1 elements containing an empty string, e.g. for count = 5:
`list{0}' has value `'
`list{1}' has value `'
`list{2}' has value `'
`list{3}' has value `'
`list{4}' has value `'
`list{5}' has value `'
The "obvious" solution would be to use a Cloner with your query result as number of copies, followed by a ListBuilder.
You can also accomplish the same thing using Python, it is probably also more efficient, performance-wise:
import fmeobjects
def generate_list(feature):
items_to_create = int(feature.getAttribute('count') or 0) + 1
items = r''] * items_to_create
feature.setAttribute('list{}', items)You need to supply an attribute "count" and it will return a list called "list{}" with count+1 elements containing an empty string, e.g. for count = 5:
`list{0}' has value `'
`list{1}' has value `'
`list{2}' has value `'
`list{3}' has value `'
`list{4}' has value `'
`list{5}' has value `'
For example:
For example:
import fmeobjects
def generate_list(feature):
items_to_create = int(feature.getAttribute('count') or 0) + 1
for n in range(items_to_create):
feature.setAttribute('list{%s}' % n, n)
Interestingly the XMLXQueryExtractor with this XQuery expression works as well. Just for your information.
fme:set-list-attribute("list{}", (0 to xs:integer(fme:get-attribute("count"))))# I personally call this transformer "XQueryCaller".
Interestingly the XMLXQueryExtractor with this XQuery expression works as well. Just for your information.
fme:set-list-attribute("list{}", (0 to xs:integer(fme:get-attribute("count"))))# I personally call this transformer "XQueryCaller".
Interestingly the XMLXQueryExtractor with this XQuery expression works as well. Just for your information.
fme:set-list-attribute("list{}", (0 to xs:integer(fme:get-attribute("count"))))# I personally call this transformer "XQueryCaller".