This might rather be a simple task, but so far i have no clue how it works to merge and concatenate joined_list elements.
I want to concatenate the two element values into one string and at the end write all the list elements out into one attribute.
Result should be {KA:28,KA:12,KA:4}
+3
if you like to stick to transformers (rather then diving into some snaky script)
you could just explode the list and string-concatenate depthto and strat. As every index in the list is a record.
Then rebuild the list (list builder, no group by) with these concatenated items and use listconcatenator to create one attribute.
Finally, stringconcatenator to get the curly braces on.
+10
But if you did want to dive into some snaky script, something like this in a python caller would work
import fme
import fmeobjects
def concat_list(feature):
depthto = feature.getAttribute('_join_list{}.depthto')
strat = feature.getAttribute('_join_list{}.strat')
for i, val in enumerate(depthto):
feature.setAttribute('newlist{'+str(i)+'}.newattribute',depthto[i]+strat[i])
+17
Alternatively, XQuery can also be used, although it's not XML operation.
XQuery expression:
let $start := fme:get-list-attribute('_join_list{}.start')
let $depthto := fme:get-list-attribute('_join_list{}.depthto')
for $i in (1 to count($start))
return $start[$i]||':'||$depthto[$i]
thanks for the two variants, both of which work great - have to try out also the xquery...
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.