Hi all, I'm still working on a solution for this problem https://community.hortonworks.com/questions/248972/nifi-script-for-json-content-manipulation-before-j.html Following the recommendation of @Rosa Negra I try to do this with record-processing along this article of @Shu (thanks for this) https://community.hortonworks.com/content/kbentry/189642/update-the-contents-of-flowfile-by-using-updaterec.html Input-JSON {
"user": "Justen",
"stand": "20190702121621",
"table": [
{
"zn": 1,
"elem_user": "Meier",
"elem_stand": "20190705081410",
"dnr": "(0)",
"group": "1"
},
{
"elem_stand": "20190706201918",
"zn": 2,
"elem_user": "Schmidt",
"dnr": "(0)",
"group": "2"
}
]
} Desired Output-JSON {
"user": "Justen",
"stand": "2019-07-02 10:16:21",
"table": [
{
"zn": 1,
"elem_user": "Meier",
"elem_stand": "2019-07-05 06:14:10",
"dnr": "(0)",
"group": "1",
"dnr_group": "V-00-01"
},
{
"elem_stand": "2019-07-06 18:19:18",
"zn": 2,
"elem_user": "Schmidt",
"dnr": "(0)",
"group": "2",
"dnr_group": "V-00-02"
}
]
} actual Output-JSON of my flow [ {
"name" : "Justen",
"stand" : "2019-07-02 10:16:21.000",
"table" : [ {
"zn" : 1,
"elem_user" : "Meier",
"elem_stand" : "2019-07-05 06:14:10.000",
"dnr" : "(0)",
"group" : "1",
"dnr_group" : "(0)(0)12" ========> first expected "(0) 1"; ideal case "V-00-01"
}, {
"zn" : 2,
"elem_user" : "Schmidt",
"elem_stand" : "2019-07-06 18:19:18.000",
"dnr" : "(0)",
"group" : "2",
"dnr_group" : "(0)(0)12" ========> first expected "(0) 2"; ideal case "V-00-02"
} ]
} ] I had success with formatting the timestamps (stand, elem_stand)! But I can't find the rigt syntax for RecordPath setting "dnr_group". All examples here https://nifi.apache.org/docs.html in Apache NiFi RecordPath Guide don't show how to use functions working with elements of an array. In the second UpdateRecord (Change Value - Record Path) I tried "Property" /table[0..-1]/dnr_group for access on all elements which works, but at "Value" I don't know how to reference the elements dnr and group of the single entry. My aim is still to build this expression which works in EL... ${DNR:substringAfter('('):substringBefore(')'):toNumber()
:lt( 10 )
:ifElse(${DNR:substringAfter('('):substringBefore(')'):prepend('0')},
${DNR:substringAfter('('):substringBefore(')')})
:append('-'):append(${GROUP:toNumber()
:lt( 10 )
:ifElse(${GROUP:prepend('0')},
${GROUP})})
:prepend('V-')} Please have a look on the attachment which shows anything I defined in NiFi. Thanks for any help!
... View more
