Hi,
When I'm polling/reading a file in CSV format and the file content have some rows get null in end of the line.Then the file adapter throwing below error.
Gives following error while polling:
Error while translating.
Translation exception.
Error occurred while translating content from file /nonftp/DEV/FilePickTest/test.csv
Please make sure that the file content conforms to the schema. Make necessary changes to the file content or the schema.
Below is the sample format of file. If we mention some space at end it's working. In my case some records receive qty as null.
id,name,qty
1,aaa,20
2,bbb,
can some one help on this scenario.
Thanks,
Phani