@CJoe36 couple of things you need to do here: Get the value of the column into an attribute. Create routes based on the value of attribute. For #1 there are a few ways. First, you can create a flow that uses a CSV Reader and a known schema. Using this you can translate and parse the columns. This requires multiple processors and CSVReader Controller Service. Two, you can just use ExtractText with regex (one processor). here is example of ExtractText to get a Quantity and SKU from an inventory CSV. Notice the regex codes used with the commas, and the () indicating which field maps to the attribute defined (sku or qty). qty: .*?,,.*?,,(\d+)$ sku: (.*?),,.*?,,.*? If your CSV is 10 columns, and #5 is your value, you probably want something like this: ,,,,(.*?),,,,, For #2 you want to use RouteOnAttribute Processor with routes defined using NiFi Expression Language. You define a route, then when defined you can chose it for downstream of RouteOnAttribute. Anything else will go to unmatched. Here is an example: And Routed: If this reply helps answer your question, please mark it as a Solution.
... View more
