Datainsert table with NaN values into SQL table as NULLs
4 views (last 30 days)
Show older comments
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 Comments
Answers (1)
Bhavesh Bhatt
on 16 Aug 2016
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 Comment
Ledger Yu
on 8 Jan 2019
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.
See Also
Categories
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!