Hello, I believe the function that you are looking for in order to combine the fields is the concat() function. So you can set the /NewPropertyField property to concat(/somefield, /anotherid)
The easiest way to filter out fields that you don't want is to simply remove them from the schema that the writer is using. So you could have data coming in with say 10 fields and if your Avro Writer were to use a schema that had only 5 fields, the other 5 would simply be dropped. Does that make sense? Thanks -Mark > On May 2, 2018, at 1:08 PM, B <[email protected]> wrote: > > Hi im trying to updaterecord an avro file to have a field combined like a > stringjoin but these functions dont really work with recordpaths > > Prop name ------ prop value > > /NewPropertyField ------ string-join(/somefield, /anotherid) > > I also want to delete fields no need to have them as null. Just remove the > key from avro flowfile-content. > > Oldid <---- now deleted from multiple avro file Records as it comes in from > sftp. So sender database has more fields than receiver database. > > Ideas? QueryRecord also seems to completely change my avros too crazily so im > not sure I can use that.
