I currently have JSON objects that are returning in FME very well. During the migration there are approx. 1,500 updates that need to be ran changing coded values to a description for storage in a data warehouse. This can be accomplished running an update that is prepopulated then passed to the "Update" port on the updater.
replace(xs:string($x(fme:get-attribute("FIELD_NAME"))),xs:string(fme:get-attribute("code")),fme:get-attribute("name"))
The issue is running 1,500 updates on 2,000 records takes 12+ minutes. The question is, is there a way to get the JSON Updater to updated multiple replacements at the same time. I have attempted to use the JSON Node updates and get errors.
Attached is a simplified version where I am attempting to change json["features"]["attributes"]/ASSETGROUP from 1,2,3,4 to One, Two, Three, Four where there is a match.
Thanks in advanced!!