Member since
12-28-2019
3
Posts
0
Kudos Received
0
Solutions
12-30-2019
12:39 PM
thanks a lot. it worked with the new regex code.
... View more
12-29-2019
03:34 PM
@stevenmatison Thanks a lot for your reply. very much appreciated. I tried it but got stuck in the ExtractText processor. My real file consists of 13 columns and #4 is the relevant one with the needed value. The input Flow File that feeds the ExtractText processor looks like this: #4 is value 25.0 (before "cpm") Meanwhile i removed the headers since i was not sure if that has got an impact or not. So what i did next in ExtractText processor is creating a new property named Value: ,,,(.*?),,,,,,,,, But when i run the workflow all the flow files goes unmatched off the ExtractText processor. So there are no matched ones that go to RouteOnAttribute. I really don't know what went wrong here. Thank you & Regards
... View more
12-28-2019
03:02 PM
Hi,
I would like to route flow files based on a column's value of a csv file. i have splitted a csv file into many csv files with the content: header and 1 row of the dataframe. so if the inital csv file consisted of 50 rows i will have 50 new csv files. i did this with the SplitRecord processor and a csv-reader/writer. The i have a UpdateAttribute processor to a UUID to these 50 files. Now, i would like to route those files based on a column's value. is this possible?
Let's say column number 5 has got numeric values and want to route all flow files with a value bigger than 50. How can i achieve that?
Thank you in advance for your help and advice
... View more
Labels:
- Labels:
-
Apache NiFi