https://community.cloudera.com/t5/Support-Questions/How-to-get-Flowfiles-with-avro-extension-and-specific-prefix/m-p/242876#M204675 <P>I am trying s simple workflow ExecuteSQL -&gt; PutSFTP, I want my flowfiles to be with .avro extension as well as I want to add either a prefix or suffix to the file name. For example if I am extracting employee data then I want flowfile name should be employee&lt;timestamp/randomnumber&gt;.avro</P><P><A rel="user" href="https://community.cloudera.com/users/18929/yaswanthmuppireddy.html" nodeid="18929">@Shu</A> <A rel="user" href="https://community.cloudera.com/users/641/mburgess.html" nodeid="641">@Matt Burgess</A> <A rel="user" href="https://community.cloudera.com/users/140/nsabharwal.html" nodeid="140">@Neeraj Sabharwal</A></P><H1></H1> Fri, 25 Jan 2019 05:00:51 GMT raghupradeepl 2019-01-25T05:00:51Z https://community.cloudera.com/t5/Support-Questions/How-to-get-Flowfiles-with-avro-extension-and-specific-prefix/m-p/242876#M204675 <P>I am trying s simple workflow ExecuteSQL -&gt; PutSFTP, I want my flowfiles to be with .avro extension as well as I want to add either a prefix or suffix to the file name. For example if I am extracting employee data then I want flowfile name should be employee&lt;timestamp/randomnumber&gt;.avro</P><P><A rel="user" href="https://community.cloudera.com/users/18929/yaswanthmuppireddy.html" nodeid="18929">@Shu</A> <A rel="user" href="https://community.cloudera.com/users/641/mburgess.html" nodeid="641">@Matt Burgess</A> <A rel="user" href="https://community.cloudera.com/users/140/nsabharwal.html" nodeid="140">@Neeraj Sabharwal</A></P><H1></H1> Fri, 25 Jan 2019 05:00:51 GMT https://community.cloudera.com/t5/Support-Questions/How-to-get-Flowfiles-with-avro-extension-and-specific-prefix/m-p/242876#M204675 raghupradeepl 2019-01-25T05:00:51Z https://community.cloudera.com/t5/Support-Questions/How-to-get-Flowfiles-with-avro-extension-and-specific-prefix/m-p/242877#M204676 <P>I was able to find solution similar to <A href="https://community.hortonworks.com/answers/74595/view.html" target="_blank">https://community.hortonworks.com/answers/74595/view.html</A> Thanks <A rel="user" href="https://community.cloudera.com/users/11098/dpinkston.html" nodeid="11098">@Devin Pinkston</A></P><P>I used as below</P><P>ExecuteSQL -&gt; UpdateAttribute added a property "filename" with value "employee.${filename}.${now():format("yyyy-MM-dd-HH-mm-ss-SSS")}.avro" -&gt; PutSFTP</P> Fri, 25 Jan 2019 06:07:10 GMT https://community.cloudera.com/t5/Support-Questions/How-to-get-Flowfiles-with-avro-extension-and-specific-prefix/m-p/242877#M204676 raghupradeepl 2019-01-25T06:07:10Z