PutDatabaseRecord :Record does not have a value for the Required column 'name'

[#1]

I am new to Nifi and trying to load csv data in postgres but I am getting error:

FlowFile[filename=test_data.csv]. Routing to failure.: java.lang.IllegalArgumentException: Record does not have a value for the Required column 'name'

so I have checked everything and the csv file I am uploading contains the data.

I have also checked solutions for issues like this but nothing worked out. I will attach liks to the screenshots it contains the configuration for PutDatabaseRecord and the query for the table I created in postgre and screenshot of the csv file. 

https://drive.google.com/file/d/1TCJTcNJHRslG4wEct1eZmuYz54Gp9e9o/view?usp=drive_link

https://drive.google.com/file/d/1Ye6pggRN4YTQVGxylNarjZh4dlX-ByQ1/view?usp=drive_link

https://drive.google.com/file/d/17zLRe88DSssU9DI3rrJLCHQmUgAj9FYX/view?usp=drive_link

https://drive.google.com/file/d/1XKt1jbZks8jE0kO4CrT3nmRR4LFcIn1e/view?usp=drive_link

Note: please let me know how I can upload image here directly

[#2]

@Runa27 

You should be able to take a screenshot and then just right click an paste it to the response window.  It may paste small, so click on it and drag the corner to make it large enough that it can be read.  Once you click reply, readers of your post will not have option to resize themselves.

Thanks,
Matt

[#3]

@Runa27 

Without details of your database table structure/configuration and your test file, it would be challenging to identify your exact issue.

Have you tried setting the "Unmatched Column Behavior" property to "Ignore Unmatched Columns" or "Warn on Unmatched Columns" to see if that makes a difference?

Can you share how your CSVReader has been configured?

Please help our community grow. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Thank you,
Matt

[#4]

@MattWho 

This is the entire flow 

this is the data I am trying to insert

"Have you tried setting the "Unmatched Column Behavior" property to "Ignore Unmatched Columns" or "Warn on Unmatched Columns" to see if that makes a difference?" Yes I tried that but it fails

The CSV reader configurations:

Please let me know if you need any other information to help me solve this I am trying to solve this from the past 4 days

[#5 · Accepted solution]

@MattWho  

I have found the solution for that. The error was because of the semicolon in the CSV file. I have changed it to comma ","because in my configrations the seprator value was comma not semicolon

before:

name;age;email
john doe;56;[email protected]
hamed;25;[email protected]
arjun;55;[email protected]
ali;21;[email protected]
saleh;16;[email protected]

After:

name,age,email
john doe,56,[email protected]
hamed,25,[email protected]
arjun,55,[email protected]
ali,21,[email protected]
saleh,16,[email protected]