'Nifi LookupAttribute processor with SimpleCsvFileLookupService doesn't work

I'd like to use a CSV file as a lookup table to update some attributes.

So I figured the LookUpAttribute processor was what I needed. I configured it with as SimpleCsvFileLookupService as the Lookup Service, but I can't get it to work yet.

My SimpleCsvFileLookupService is configured but stays in a "enabling" state, and the LookUpAttribute processor still tells me it's "invalid because performing validation depends on referencing a Controller Service that is currently disabled".

I dont understand why it doesn't enable. Has somebody used these components ? Thx

Dataflow LookAttribute properties Controller services

Edit : I didn't see the message in the left. It says the mapping for "1" is not found ("1" is set as the lookup key column and in the csv the header row is "1;2;3;4;5;6;7;8".

What am I missing ? I can't find any explanation as to how to use this controller service.

Controller service warning

Edit2 : The SimpleCsvFileLookupService properties SimpleCsvFileLookupService properties

Edit3 : Extract of the csv file csv file



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source