Datainsert table with NaN values into SQL table as NULLs
9 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (1)
Bhavesh Bhatt
il 16 Ago 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 Commento
Ledger Yu
il 8 Gen 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.
Vedere anche
Categorie
Scopri di più su Matrices and Arrays in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!