Data Load - Blank Field
SummaryData Load - Blank Field
I am attempting to load some data and have a couple of questions:
I am able to successfully load my data file. I have a couple of cells that are blank. I would have expected to get an error message for these but didn't, the amounts for the blank cells are being added to LASF. I am assuming it is something in the properties/setup of the load rule but I don't know what. Any ideas?
Second Question, I would like these blank item to go into an UNDEF. In the load rule I tried to do the find " " (or just left a blank and #missing) and replace with UNDEF, but that doesn't seem to work. Any ideas how to identify and replace the blanks. Thanks