@Garima Verma , you can use RouteOnAttribute Processor to filter out the records based on the condition. One way to drop the column is to use ExtractText processor that assigns the columns to attributes using regular expression and in ReplaceText processor, you can drop that attribute from the FlowFile content. You can transform your null values by using ReplaceText processor which uses Nifi Expression language. I would recommend you to go through Nifi Processors and Nifi Expression language. Here is the link: https://nifi.apache.org/docs.html You can go through all processors and expression language guide here. ... View more