I found another way to implement the right join. If you use the field sql_on, there is no RIGHT JOIN option. However, if you use sql: RIGHT JOIN dataset. table as table on a.id = b.id then i got the desred result without nulls. Hope it helps.