lironbaram
Partner - Master III
2020-04-01
02:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ',');