Displaying 1 result from an estimated 1 matches for "new_qti".
Did you mean:
new_qty
2012 Aug 20
1
function case in sqldf (datas from oracle) with a null value
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