the map join transform is largely ok