No problem. Please confirm your version of data.table is 1.8.2 (latest on CRAN)? Which contains these bug fixes :
o merge() with common names, and, all.y=TRUE (or all=TRUE) no longer returns an error, #2011. o merge() is now correct when all=TRUE but there are no common values in the two data.tables, fixing #2114. Thanks to Karl Ove Hufthammer for reporting. Tests added. If you are running 1.8.2 then please confirm test.data.table() returns precisely 717 tests passed. Matthew > Sorry for being so inprecise, > > I attached a file with two data table objects in it > > trying to merge them with > > mydataset=merge(mydataset,savings_wide,all.x=TRUE) > > results in > > Fehler in setcolorder(dt, c(setdiff(names(dt), end), end)) : > neworder is length 196 but x has 193 columns. > > the column names in the dataset that causes the failing are > > [1] "GEO" "time" > "Final consumption expenditure" > [4] "Gross capital formation" "Net saving" > > > > 2012/10/9 Matthew Dowle <[email protected]> > >> >> Hi Johannes, >> >> Welcome. >> >> Thanks. It would be great if you could provide example data and explain >> what fails means. Error message or wrong result? >> >> But, by chance, is it the same as this one? : >> >> >> https://r-forge.r-project.org/tracker/index.php?func=detail&aid=2193&group_id=240&atid=975 >> >> Matthew >> >> >> >> I think I found a bug, merge fails when there are columns with >> spaces >> >> in >> >> the column name >> >> >> >> mydataset=merge(dd,savings_wide,all.x=TRUE) >> >> >> >> if there are no spaces in column names the merge works. >> >> >> >> btw: data.table is a really great tool ! thanks >> >> >> >> johannes Kutsam >> >> >> >> >> >> http://johanneskutsam.blogspot.co.at/ >> >> >> >> >> >> >> > >> > >> > -- >> > >> > *Pepi - Personaleinsatzplanung* >> > www.personaleinsatz.at >> > >> > *Kutsam - Wo Mode zum Erlebnis wird!* >> > >> > Kutsam Gmbh & CoKG >> > Johannes Kutsam >> > Hauptplatz 21 >> > 4540 Bad Hall >> > >> > 07258 7501 >> > www.kutsam.at >> > [email protected] >> > _______________________________________________ >> > datatable-help mailing list >> > [email protected] >> > >> https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help >> >> >> > > > -- > > *Pepi - Personaleinsatzplanung* > www.personaleinsatz.at > > *Kutsam - Wo Mode zum Erlebnis wird!* > > Kutsam Gmbh & CoKG > Johannes Kutsam > Hauptplatz 21 > 4540 Bad Hall > > 07258 7501 > www.kutsam.at > [email protected] > _______________________________________________ datatable-help mailing list [email protected] https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
