Forum Discussion
shuang
7 years agoFrequent Visitor
Combine columns from different tables
Hello, Newbie here. I know others have posted similar questions, but couldn't find a way to do mine. So I have two tables: Table 1 ID Collection Date species Latitude Longitude Test...
- 7 years ago
Rename the Column Head of both table, and make sure that the two are equal.
IN powerquery select the most recent table, and then "Apend New Queries"
shuang
7 years agoFrequent Visitor
They have different rows. Table 1 has 2000 plus rows and Table 2 has about 300 rows. They are totally different set of data and are not related in anyway. Table 1 is from a very old database and Table 2 is a newer one. We just need to put them together. Thanks.
rafaelmpsantos
Responsive Resident
7 years agoRename the Column Head of both table, and make sure that the two are equal.
IN powerquery select the most recent table, and then "Apend New Queries"