https://community.cloudera.com/t5/Support-Questions/add-field-to-csv-file-based-on-other-field-value/m-p/177560#M139808 <P><A rel="user" href="https://community.cloudera.com/users/20202/samgoldopamp.html" nodeid="20202" target="_blank">@Sammy Gold</A>, </P><P>i tried to add new element to the csv content we can add new field by changing AvroSchemaRegistry to below</P><PRE>{"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" },<STRONG>{ "name": "heightmm", "type": "int" }]}</STRONG><STRONG> </STRONG></PRE><P>but we<STRONG> cannot do math calculations</STRONG> i think..</P><P><U>Following things i tried:-</U></P><P>Replacement value strategy as<STRONG> Record Path value</STRONG> but <STRONG>it wont does any math</STRONG> on the existing <STRONG>/height</STRONG> field</P><PRE>/heightmm as /height*10,/height:multiply(10)</PRE><P><STRONG>When can this processor works to add values?</STRONG></P><P>It will work if you are going to have heightmm value as /height value then this processor works</P><P><STRONG>Replacement value strategy</STRONG> as<STRONG> Record Path value</STRONG></P><PRE>/heightmm as /height</PRE><P><STRONG>Example:-</STRONG></P><PRE>name,age,height,weight,school,heightmm <BR /> james,19,2222,56,,2222 jake,20,2222,62,,2222 sam,21,2222,55,,2222 Mike,24,2222,64,,2222</PRE><P>we can <STRONG>replace</STRONG> only with the <STRONG>existing values,</STRONG> but we cannot do math operations i think.</P><P><STRONG><U>Another way:-</U></STRONG></P><P>To add new record for the existing csv data you can <STRONG>extract the height content as attribute</STRONG> by using extract attribute processor and use replace text processor to create new record based on height attribute.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="40763-screenshot.png" style="width: 552px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/19567iF1B1C4BA219CB8BC/image-size/medium?v=v2&amp;px=400" role="button" title="40763-screenshot.png" alt="40763-screenshot.png" /></span></P><P>here we are keeping </P><PRE>Replacement Strategy property to Append </PRE><P>it will <STRONG>keeps the content as is</STRONG> and <STRONG>append the new value</STRONG> to the content.</P><P>(or)</P><P>you can use </P><PRE>Replacement Strategy property to regexreplace</PRE><PRE>Replacement value as $1${height:multiply(10)} </PRE><P>it will give <STRONG>same result</STRONG> as<STRONG> Append</STRONG> method did.</P> Sun, 18 Aug 2019 09:42:23 GMT Shu_ashu 2019-08-18T09:42:23Z