- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Extracttext processor multiple record handling
- Labels:
-
Apache NiFi
Created on ‎05-22-2021 12:03 PM - edited ‎05-22-2021 12:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to load data from the below input to db.
My input is as shown below
i, John, $100
ii, Kevin, $150
iii, Steve, $200
Created getfile, ReplaceAttributes, Extracttext, Route to attributes, putsql flow
I have managed to parse fixed width file records and replaced with comma delimited values. ExtractText processor with Enable Multiline Mode=true, Enable DOTALL Mode=true. After execution I see below in provenance event in attributes tab
line i
line.0 John
line.1 $100
Please advise how to load other two records which was not getting displayed in the attributes.
Created ‎05-24-2021 06:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The more detail you can provide, the better we may be able to assist.
Are you using custom processors? NiFi does not come with a ReplaceAttribute processor.
I am assuming your flow may actually be using:
GetFile (deprecated processor in favor of the listFile and FetchFile processors) --> UpdateAttribute --> ExtractText --> RouteOnAttribute --> putSQL
Can you share the configuration you are currently using on the above processors, so we can see what you are doing now? Perhaps you only need a few tweaks to your current design.
Thanks,
Matt
Created ‎05-24-2021 11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
