merge transform lookup into columns, rspec test