Hi.
I am using CSVExcelStorage or both reading and writing my datasets.
Read scriptlet is as below:
A = LOAD 'input.csv' USING CSVExcelStorage
(',','YES_MULTILINE','UNIX','SKIP_INPUT_HEADER');
Write scriplet is very similar as below:
STORE B INTO 'file_directory' using CSVExcelStorage
(',','YES_MULTILINE','UNIX','WRITE_OUTPUT_HEADER');
When I inspect the csv file written for storing B, I am seeing " in all
cells where the value is empty. Otherwise, the cells are populated
properly. However, some places it actually left the cell blank without even
filling it with "
Can anyone please help me understand on how to resolve this?
Thanks & Regards
Vijay
--
The contents of this e-mail are confidential and for the exclusive use of
the intended recipient. If you receive this e-mail in error please delete
it from your system immediately and notify us either by e-mail or
telephone. You should not copy, forward or otherwise disclose the content
of the e-mail. The views expressed in this communication may not
necessarily be the view held by WHISHWORKS.
