+52Hi,
I'm working with the transformer JsonTemplater to create a json file. The source is a list of attributes, for example:
_list{0}.Date
_list{1}.Date
_list{0}.Age
_list{1}.Age
My Workspace translate with successful with just list of attribute:
{
"Attributes" : [
for $value in fme:get-list-attribute(("_list{}.Date")
return {"Date" : $value}]
}
My question: How can I configure to receive more than list of attribute, in this case _list{}.Age ?
Thanks
Best answer by jdh
This may not be the most elegant solution, but should work.
{
"Attributes":[ for $Age at $pos in fme:get-list-attribute("_list{}.Age")
let $Date := fme:get-attribute(concat("_list{",$pos - 1,"}.Date"))
return {"Date":$Date, "Age": $Age}]
}
+40This may not be the most elegant solution, but should work.
{
"Attributes":[ for $Age at $pos in fme:get-list-attribute("_list{}.Age")
let $Date := fme:get-attribute(concat("_list{",$pos - 1,"}.Date"))
return {"Date":$Date, "Age": $Age}]
}
This may not be the most elegant solution, but should work.
{
"Attributes":[ for $Age at $pos in fme:get-list-attribute("_list{}.Age")
let $Date := fme:get-attribute(concat("_list{",$pos - 1,"}.Date"))
return {"Date":$Date, "Age": $Age}]
}
Is works now, thank you!
Danilo
This may not be the most elegant solution, but should work.
{
"Attributes":[ for $Age at $pos in fme:get-list-attribute("_list{}.Age")
let $Date := fme:get-attribute(concat("_list{",$pos - 1,"}.Date"))
return {"Date":$Date, "Age": $Age}]
}
{
"Attrbutes" : [
let $dates := fme:get-list-attribute("_list{}.Date")
for $age at $p in fme:get-list-attribute("_list{}.Age")
return { "Date" : $dates[$p], "Age" : $age }
]
}
{
"Attrbutes" : [
let $dates := fme:get-list-attribute("_list{}.Date")
for $age at $p in fme:get-list-attribute("_list{}.Age")
return { "Date" : $dates[$p], "Age" : $age }
]
}
, thank you!
+7This may not be the most elegant solution, but should work.
{
"Attributes":[ for $Age at $pos in fme:get-list-attribute("_list{}.Age")
let $Date := fme:get-attribute(concat("_list{",$pos - 1,"}.Date"))
return {"Date":$Date, "Age": $Age}]
}
@takashi how would I make your expression work with 3 list attributes?
@takashi how would I make your expression work with 3 list attributes?
example:
{
"Attributes" : [
let $a := fme:get-list-attribute("_list{}.a")
let $b := fme:get-list-attribute("_list{}.b")
for $c at $i in fme:get-list-attribute("_list{}.c")
return
{
"A" : $a[$i],
"B" : $b[$i],
"C" : $c
}
]
}