+10Hello 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
Best answer by david_r
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 = [''] * 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 = [''] * 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 = [''] * 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".
+10Interestingly 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".