Dear All,
I am new in ADF and using 12.2.1. I am uploading data into database table using af:inputfile and CSVParser class. Data is uploading correctly in database when all columns are filled but whenever csv file has any null (blank) value in its column then CSVParser class didnot recognize it and get next columns value and set it to previous column. I also tried an other example which is using different class to upload date but not get success.
For Ex:
Id Name Dept
1 abc Dept1
2 cde Dept2
3 Dept3
In above example first two line are perfectly inserted in table while in third line Id goes to ID column, because of Name column's value is null CSVParser class does not recognize it and put Dept3 into Name's column.
Please help how to handle this.
Thanks in advance.
Regards,