Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Count of rows in Excel sheet and that uploaded don't match

Vinit Kini-Oracle20 hours ago

When you upload a data sheet containing X rows using file browse and data load definitions. The count displayed after sucessfull upload is not X but Y, which is greater than X.

Tried analysing the excel file for issues or values in any of the cells of a row, but did not find any.

As an attempt to troubleshoot, I did a SAVE AS CSV file. On opening the CSV file, found it contained Y rows, all BLANK.

Went to last row and deleted all EMPTY ROWS about 10-15 and re-tried it, this time it only contained X rows as requried.

So issue is, even though we do not see any values in the cells, the residual NULL forces the loaded to consider it as a row with empty values. On DELETEING the rows, the issue is sorted.

Thought of sharing this with others, so they can resolve ASAP.

Comments
Post Details
Added 20 hours ago
0 comments
36 views