I ve a dataset which contans a field out off the database with NA as result, which I must keep. The output I created with
write.table(dataset,row.names=FALSE,sep=";",na=""
,file="C:\Users\mwijn\OneDrive\Documenten\Engie\Output\Delete_File.csv")
because I use na="" all fields are blank, but the field SS Reason should contain na if empty. could use a IF then statement I think but due to I ve less experience in R, found no correct way to solve this.
Hope someone can help in this.
File SSV Action Wall Mount SS Reason Number Floors Height Cable
EXPORT N IRREG 2
EXPORT N IRREG 3
EXPORT N IRREG 2
EXPORT Y 2 5
EXPORT N IRREG 2
EXPORT Y 2 5
EXPORT Y 2 5
EXPORT N IRREG 2
EXPORT Y 2 5
EXPORT N IRREG 2
EXPORT N IRREG 2
EXPORT N IRREG 2
EXPORT N IRREG 2
EXPORT N IRREG 2
EXPORT N IRREG 2