Hi,
I have a data file, with new line ( '\n' ) separated.
I'm using apex data loader wizard to upload data to the DB table.
1. This is the data i had loaded
2. In the next window (data mapping) i could see that the blank row is considered but the last row "sac_1234" has got excluded.
3. Data Validation part:
4. Final part:
In the final process, it is clear that the null row is excluded, as it was a not null column.
But my concern is due to the presence of a blank record, one genuine data has been excluded by the loader window.
How can i avoid this scenario ?
Can i add a validation in the first stage itself, notifying the end user to remove the blank rows from their data file ?
Please help/advise.
Please let me know if more information is required.
Thanks,
Sachin