You have to create a separate case statement for each column you are trying to update similar to what  is done for the shipment number. ... View more

Hi, I think you can achieve this in two shift transformation as follows:     [ { // 1st transformation is basically to isolate // "OC" value reference into Orders.ValueReference "operation": "shift", "spec": { "Orders": { "*": { "Headers": "Orders[#2].&", "Goods": "Orders[#2].&", "References": { "*": { "TypeReference": { "OC": { "@(2,ValueReference)": "Orders[#2].ValueReference" } } } } } } } }, //2ed Transformation is the same as you had except for //fetching the isolated ValueReference above //into its own Array based on the GoodsDetails array { "operation": "shift", "spec": { "Orders": { "*": { "Headers": "header", "Goods": { "*": { "GoodsDetails": { "*": { "@(2,GoodsTypeName)": "rows.GoodsTypeName", "Packs": "rows.Packs", "@(4,ValueReference)": "rows.ValueReference" } } } } } } } } ]     If the helps please accept solution. Thanks ... View more

hi @Ray82, Assuming that you have a way to identify where you need to add your ";", you can easily use NiFi's Expression Language to add it. More details are available here: https://nifi.apache.org/docs/nifi-docs/html/expression-language-guide.html.   At first sight, if you identify a pattern, you can use any function with replace in order to replace your white space with semicolon. Next, to add the semicolon between your characters, you can use an regex, based on your pattern. In terms of processors, you have ReplaceText, UpdateAttribute, UpdateRecord, etc .... so you have plenty to choose from 🙂 ... View more

This should work, in the past i've tried the same command with ExecuteProcess but it didn't accept upstream connections.   Your solution is working great!   Many thabks for your supporto. ... View more