@Lallagreta  Make sure you do not have any line returns in the values for your dynamic properties added in the UpdateAttribute processor.  When you click on the value field for each property you should not see a line "2". For example: Above would result in the value assigned to the FlowFile Attribute having a line return.  If this is the case, edit the properties value(s) to remove the line returns so you only see one line (1). Hope this helps, Matt ... View more

@murali2425   The solution you are looking for is QueryRecord configured with a CSV Record Reader and Record Writer.   You also have UpdateRecord and ConvertRecord which can use the Readers/Writers.  This method is preferred over splitting the file and adds some nice functionality.  This method allows you to provide a schema for both the inbound csv (reader) and the downstream csv (writer).   Using QueryRecord you should be able to split the file, and set attribute of filename set to column1.  At the end of the flow you should be able to leverage that filename attribute to resave the new file.   You can find some specific examples and configuration screen shots here:   https://community.cloudera.com/t5/Community-Articles/Running-SQL-on-FlowFiles-using-QueryRecord-Processor-Apache/ta-p/246671   If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.   Thanks, Steven ... View more