topic Load Null Values in App Development

Load Null Values

hasmyt — Thu, 16 Jun 2022 07:36:50 GMT

I have an excel table that looks like this

Col1 Col2 A B C D

'abc' 'A' 3 15 - 4

'abd' 'B' - 1 - 10

When I convert this into a crosstable, the null values don't show up. However I need the null values as well. How do I do that?

lironbaram — Thu, 16 Jun 2022 08:19:38 GMT

you can try this approach

nullasvalue Score,Value;
//Set NullValue = 'NULL';

DataTemp:
LOAD
ID,
Score,
Value
FROM [lib://Downloads/test.xlsx]
(ooxml, embedded labels, table is Sheet1);

CrossTable(Type,Value,1)
load *
Resident DataTemp;

drop table DataTemp;