@Sammy Gold, i tried to add new element to the csv content we can add new field by changing AvroSchemaRegistry to below {"name": "origFormatName","namespace": "someFields","type": "record","fields": [{ "name": "name", "type": "string" },{ "name": "age", "type": "int" },{ "name": "height", "type": "int" },{ "name": "weight", "type": "int" },{ "name": "school", "type": "string" },{ "name": "heightmm", "type": "int" }]} but we cannot do math calculations i think.. Following things i tried:- Replacement value strategy as Record Path value but it wont does any math on the existing /height field /heightmm as /height*10,/height:multiply(10) When can this processor works to add values? It will work if you are going to have heightmm value as /height value then this processor works Replacement value strategy as Record Path value /heightmm as /height Example:- name,age,height,weight,school,heightmm james,19,2222,56,,2222
jake,20,2222,62,,2222
sam,21,2222,55,,2222
Mike,24,2222,64,,2222 we can replace only with the existing values, but we cannot do math operations i think. Another way:- To add new record for the existing csv data you can extract the height content as attribute by using extract attribute processor and use replace text processor to create new record based on height attribute. here we are keeping Replacement Strategy property to Append it will keeps the content as is and append the new value to the content. (or) you can use Replacement Strategy property to regexreplace Replacement value as $1${height:multiply(10)} it will give same result as Append method did.
... View more
