Some progress: I've modified the transformation like this: [{ "operation": "shift", "spec": { "Orders": { "*": { "Headers": { "*": "header.&" }, "Locations": { "Shipper": { "*": "sender.&" }, "Consignee": { "*": "consignee.&" }, "Unload": { "*": "unload.&" } }, "Goods": { "*": { "GoodsDetails": { "*": { "@(2,GoodsTypeName)": "rows.GoodsTypeName", "@(4,Locations.Consignee.ConsigneeName)": "rows.ConsigneeName", "@(4,Locations.Consignee.IdPlanToLocCUS)": "rows.IdPlanToLocCUS", "@(4,Locations.Consignee.ConsigneeAddress)": "rows.ConsigneeAddress", "@(4,Locations.Consignee.ConsigneeCountry)": "rows.ConsigneeCountry", "@(4,Locations.Consignee.ConsigneeEmail)": "rows.ConsigneeEmail", "@(4,Locations.Consignee.ConsigneeNotes)": "rows.ConsigneeNotes", "@(4,Locations.Consignee.ConsigneeReference)": "rows.ConsigneeReference", "@(4,Locations.Consignee.ConsigneeRegion)": "rows.ConsigneeRegion", "@(4,Locations.Consignee.ConsigneeTel)": "rows.ConsigneeTel", "@(4,Locations.Consignee.ConsigneeTown)": "rows.ConsigneeTown", "@(4,Locations.Consignee.ConsigneeZipCode)": "rows.ConsigneeZipCode", "Packs": "rows.Packs", "NetWeight": "rows.NetWeight", "GrossWeight": "rows.GrossWeight", "Cube": "rows.Cube", "Meters": "rows.Meters", "CodiceUnivocoCollo_1": "rows.CodiceUnivocoCollo_1", "CodiceMaster": "rows.CodiceMaster", "ItemCode": "rows.ItemCode", "Seats": "rows.Seats", "Height": "rows.Height", "Width": "rows.Width", "Depth": "rows.Depth", "Note": "rows.Note", "@(4,Locations.Unload.UnloadName)": "rows.UnloadName", "@(4,Locations.Unload.IdShipToLocCUS)": "rows.IdShipToLocCUS", "@(4,Locations.Unload.UnloadAddress)": "rows.UnloadAddress", "@(4,Locations.Unload.UnloadCalendarNote)": "rows.UnloadCalendarNote", "@(4,Locations.Unload.UnloadCountry)": "rows.UnloadCountry", "@(4,Locations.Unload.UnloadDate)": "rows.UnloadDate", "@(4,Locations.Unload.UnloadEmail)": "rows.UnloadEmail", "@(4,Locations.Unload.UnloadNotes)": "rows.UnloadNotes", "@(4,Locations.Unload.UnloadReference)": "rows.UnloadReference", "@(4,Locations.Unload.UnloadRegion)": "rows.UnloadRegion", "@(4,Locations.Unload.UnloadTel)": "rows.UnloadTel", "@(4,Locations.Unload.UnloadTime)": "rows.UnloadTime", "@(4,Locations.Unload.UnloadTown)": "rows.UnloadTown", "@(4,Locations.Unload.UnloadZipCode)": "rows.UnloadZipCode", "@(4,Locations.Unload.ObbligatoryUnloadDate)": "rows.ObbligatoryUnloadDate", "@(4,References)": { "*": { "TypeReference": { "OC": { "@(2,ValueReference)": "rows.info1[]" }, "CM": { "@(2,ValueReference)": "rows.info7[]" } } } } } } } } } } } }, { "operation": "cardinality", "spec": { "header": { "*": "ONE" }, "sender": { "*": "ONE" }, "consignee": { "*": "ONE" }, "unload": { "*": "ONE" } } }, { "operation": "shift", "spec": { "header": { "*": "header.&" }, "sender": { "*": "sender.&" }, "consignee": { "*": "consignee.&" }, "unload": { "*": "unload.&" }, "rows": { "*" : { "*" : { "@": "rows[&1].&2" } } } } }]   Everything works as expected when i have multiple elements in GoodDetails like this: "GoodsDetails": [ { "Packs": 1, "NetWeight": 3.800000, "GrossWeight": 4.800000, "Cube": 0.693000, "Meters": 0.000000, "Note": "good note" }, { "Packs": 1, "NetWeight": 3.800000, "GrossWeight": 4.800000, "Cube": 0.693000, "Meters": 0.000000, "Note": "good note" } ]   However, when the element is only one like this: { "Packs": 1, "NetWeight": 3.800000, "GrossWeight": 4.800000, "Cube": 0.693000, "Meters": 0.000000, "Note": "good note" } The result is really bad: rows": [{ "ConsigneeZipCode": null, "UnloadZipCode": null, "info7": "230500003530", "info1": "V6157-0360", "Seats": null }, { "Packs": null }] It seems that when the element is only one, the first shift transformation does not consider resulting rows[ {}, {} ] as an array.... but something like: row{ name1: value1 name1: value2 ... }   Any suggestion really appreciate.   ... View more

Yes correct....the file is read in the first fragment, updated and then saved into a local folder....and so on for every fragment.    I want to be sure that every updare is saved without loosing data. ... View more

Moreover, how to assign multiple values when the case matches?   EX:   select *, case when F3BARC_BarcodeSegnacollo = '${barcode}' then '${Shipment_Number},${Shipment_Date},${Document_Date}' else F3SPNU_NumSpedizione end as F3SPNU_NumSpedizione F3SPNU_DataSpedizione end as F3SPNU_DataSpedizione F3SPNU_NumDocumento end as F3SPNU_NumDocumento from flowfile Many Thanks! ... View more

OK , i've found the problem. My query was: select *, case when F3BARC_BarcodeSegnacollo = '${barcode}' then '${Shipment_Number}' else F3SPNU_NumSpedizione end as F3SPNU_NumSpedizione from flowfile But fields selection won't have field in else statement like this: select F3BARC_BarcodeSegnacollo, case when F3BARC_BarcodeSegnacollo = '${barcode}' then '${Shipment_Number}' else F3SPNU_NumSpedizione end as F3SPNU_NumSpedizione from flowfile   Is there any way to make a select *? I have lots of fields to select. Many Thanks ... View more

Well, i'm not sure this query is exactly what i'm searching for. Speaking in a human way this is what i need to do: Search the element with barcode=${barcode_attribute} and if found update corresponding "shipment_number" value with ${shipment_number_attribute}, otherwise leave it as it is. So this:   [ { "reference" : "PB", "date" : "20230613", "barcode" : "C337287V28490010", "shipment_number" : "" }, { "reference" : "PB", "date" : "20230613", "barcode" : "C337287V28490011", "shipment_number" : "" }, { "reference" : "PB", "date" : "20230613", "barcode" : "C337287V28490012", "shipment_number" : "" } ] would becomes as below:   [ { "reference" : "PB", "date" : "20230613", "barcode" : "C337287V28490010", "shipment_number" : "0000023/SH" }, { "reference" : "PB", "date" : "20230613", "barcode" : "C337287V28490011", "shipment_number" : "" }, { "reference" : "PB", "date" : "20230613", "barcode" : "C337287V28490012", "shipment_number" : "" } ] Trying your query seems that does not update shipment_number field. Hope this can explain better the need.   Many Thanks ... View more

Sure I Kwon this....the question is how to add a where clause in Updare Record or QueryRecord .   In QueryRecord I ve tried an Update statement with no luck.   Will giving me always an error.     ... View more

Barcode is an attribute coming from each fragment...different on any fragment. ... View more