QlikView App Dev

Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Who Me Too'd this solution

lironbaram
Partner - Master III
Partner - Master III

hi 

this will work 

NullAsValue *;

Set NullValue = 0;


DetailTemp:
LOAD Country,
State,
[Def Value],
[User Value]
FROM
[Data.xlsx]
(ooxml, embedded labels, table is Sheet1);


Detail:
CrossTable(DATATYPE, CONSTANT, 2)
load *
resident DetailTemp;

drop Table DetailTemp;

STORE Detail INTO [DETAIL.csv] ( txt, delimiter is ',');

View solution in original post

Who Me Too'd this solution