I am importing am excel spreadsheet which was exported from a list in Sharepoint. There is one column 'X' where there are no values i.e NULL.
When I imported the file and created a pivot table, column X showed as having two disctinct values. I played with the presentation layer and discovered that I had 'Missing Symbol' values.
My theory is that someone entered and deleted a value in one of the cells, and it was no longer NULL, but not it was MISSING (according to Qlikview)
To get around this I had to put in the following expression in the load:
trim(if(isnull([field]),'',[field])) as [field]I
I don't like the idea of having to put this logic on every column on the off chance the field has been touched. Am I missing something obvious here? Has anyone else encountered this situation?
I would like to add that this is not an issue until using a pivot table. If you view the field as a list, it will only show the one value, put it into a pivot table and suddenly it is two separate values.
