NiFi: CSVRecordLookupService - Mapping Not Found

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

NiFi: CSVRecordLookupService - Mapping Not Found

johndcal
If you have ideas for me on how to solve this problem, thanks in  advance -
johndcal.

I am using a NiFi flow to create single flowfile from two input files. This
flow involves the LookupRecord processor, which requires several controller
services.  The controller service that is failing is CSVRecordLookupService
- it cannot establish the [very simple] mapping; the error reported is
below:

<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t924/img1.png>

The first file is a file of ML baseball players - the second column is
Loc_ID, which is a 3-letter code for the team's city.  The second file
contains the Loc_ID (city) and associated state name.  The first file does
not contain the name of the state - the goal is to perform the lookup and
create an output flowfile that contains the name of the state.

The file schemas and CSVRecordLookupService controller service configuration
are shown below.  Samples of the top of the input files, and the process
flow, are shown, and at the bottom of this message is a link to my xml flow
template.

input schema:
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t924/img2.png>

output schema:
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t924/img3.png>

CSVRecordLookupService controller service configuration:
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t924/img4.png>

input file sample:
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t924/img5.png>

output file sample:
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t924/img6.png>

process flow:
<http://apache-nifi-users-list.2361937.n4.nabble.com/file/t924/img7.png>

flow template: https://github.com/johndcal/NiFi-Tutorial-5-Files




--
Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/