Hi, You can use the ReplaceText Processor as follows: If you find this helpful please accept solution. Thanks ... View more

Thanks for your help @SAMSAL  ... View more

Thanks a lot for suggestion.  Original relationship helped. I am working with 1.13.2. Will check the suggested one. Thanks! ... View more

Hi @SAMSAL: I was trying to implement your solution but I didn't find a way to define a SYS_REFCURSOR in Pre-Query statements. Can you share any working simple example using Oracle DBMS? ... View more

Hi, Thank you for your support. The conversion to a date form type I had not in mind ... View more

Hi, not sure if you are repeating the attribute name in the processor dynamic property values! Make sure the different header attributes are set\add as follows:     ... View more

Hi, you can use  ReplaceText by setting the Evaluation Mode property to "Line-by-Line", then set the "Line-by-Line Evalaution Mode" to "Last Line". In the Replacement  Value set it to Empty String Set and the Search Value leave as "(?s)(^.*$)" as seen in the screenshot below:   If you find this helpful please accept solution. Thanks   ... View more

I create an XMLRecordSetWriter in the Controller Services, then using a ConvertRecord processor I'm able to read the xml record and then immediately write it out with a new root tag, which I can then pass to my next processor.  I discovered this when I was reading the documentation for the XMLRecordSetWriter.  Very first line in the documentation. 😃 https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-record-serialization-services-nar/1.7.0/org.apache.nifi.xml.XMLRecordSetWriter/index.html   ... View more

@KhASQ ,   Besides @SAMSAL solution, you can also use ReplaceText to eliminate the need of extracting the entire content as an attribute. You'd still have to set a large enough buffer, though, to ensure your largest message could be processed.   Cheers, André   ... View more

It worked for me. Thanks.   ... View more