thanks for the reply, But does not the results I need. What is confusing is that when making the first merge it gives only two cities when it should take three
travel<-data.frame(pos=1,Source=1,Destine=2) travel<-rbind(travel,data.frame(pos=1,*Source=1*,Destine=3)) travel<-rbind(travel,data.frame(pos=2,*Source=3*,Destine=4)) travel<-rbind(travel,data.frame(pos=3,*Source=2*,Destine=4)) travel<-rbind(travel,data.frame(pos=4,*Source=1*,Destine=3)) temp1 <- merge(travel, city, by.x='Source', by.y='cod') >temp1 () Source pos Destine city 1 *1* 1 2 Barcelona 2 1 1 3 Barcelona 3 1 4 3 Barcelona 4 *2 * 3 4 Madrid -- View this message in context: http://r.789695.n4.nabble.com/copy-the-columns-based-on-the-code-tp4505253p4506102.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
