Datainsert table with NaN values into SQL table as NULLs

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.

Answer 1

[Bhavesh Bhatt]

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;

[Ledger Yu]

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.