We have an excel file that we import. One particular column sometimes does not have any values in it (so its null).
If the first x number of rows being imported are null, then the import "skips" this column and the imported data is then misaligned - even though there are legitimate values in that column.
The bandaid fix that we have in place right now, is that before the file is uploaded, someone will go to that column and replace the null values for spaces in the first 10 rows (its arbitrary) and then imports the spreadsheet and it solves the issue.
Any ideas to resolve this? Has this happened to anyone before?
Please sign in to leave a comment.