Datainsert table with NaN values into SQL table as NULLs
4 次查看(过去 30 天)
显示 更早的评论
Dear Sir/Madam,
I have a matlab table with 2 numeric columns. Some values in the table are NaN. What is the best way to get these values to appear as NULL when inserted in SQL? I have been using datainsert and repeatedly get errors, even though NullNumberWrite='NaN'.
Any help would be much appreciated.
0 个评论
回答(1 个)
Bhavesh Bhatt
2016-8-16
I hope this helps -
a=[NaN,1,2,3,NaN,2,3,4,3,4,4,4,4,5,32]';
To delete the NaN entry, please type the following commands in the MATLAB command window -
>> a(isnan(a))=[];
To replace the NaN entry with 0, please type the following commands in the MATLAB command window -
>> a(isnan(a))= 0;
1 个评论
Ledger Yu
2019-1-8
OP is asking about how to insert those rows with NaN values, not removing them or replacing them. Those NaN values should still be inserted.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!