Datainsert table with NaN values into SQL table as NULLs
9 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Bhavesh Bhatt
le 16 Août 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 commentaire
Ledger Yu
le 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.
Voir également
Catégories
En savoir plus sur Matrices and Arrays dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!