Skip to content
Prev 303713 / 398506 Next

function case in sqldf (datas from oracle) with a null value

cindy.dol 
I use sqldf to join 2 dataframes from 2 distinct databases : a and b come
from old sqldf's.

sqldf("select a.*, b.*, case a.QTY when null then b.QTY else a.QTY end as
NEW_QTY" 
from a inner join b on a.OBJECT=b.OBJECT")

R doesn't understand "when null". I tried with "when NA", "when '' ", "when
' ' " but it doesn't work.



--
View this message in context: http://r.789695.n4.nabble.com/function-case-in-sqldf-datas-from-oracle-with-a-null-value-tp4640772.html
Sent from the R help mailing list archive at Nabble.com.

Thread (2 messages)

cindy.dol function case in sqldf (datas from oracle) with a null value Aug 20 Gabor Grothendieck function case in sqldf (datas from oracle) with a null value Aug 20