This content has been marked as final. Show 2 replies
I'm having a problem with loading a block of data from Excel into QV.
I'm loading data from multiple files, and most of the time i'd have something like:
but sometimes I'd get:
...where the users didn't fill in the data (maybe they didn't have any).
In this case I still need to read it in.
I have a table, where one of the fields is assigned a static value:
'Label1' as [Label],
@2 as [A],
@3 as [B],
and later I join it with another table, relying on the [Label] for the correct join.
The problem appears, when I have blank cells, the [Label] never gets assigned the value "Label1" for some reason.
I don't care if the cells are blank, NULL is fine with me, but QV doesn't even store a null character as the value for these cells.
I'm lost, any help is appreciated.