Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 status | action |
Table 2:
Sub_ID | Sample date | species | Latitude | Longitude | result |
Table 1 and 2 have no relationship. What I want to do is to creat a new table, Table 3 in this way:
combine ID from Table 1 and Sub_ID from Table 2 into column "Identification" in Table 3
combine Collection Date from Table 1 and Sample Date from Table 2 into column "Date" in Table 3
combine Test status from Table 1 and result from Table 2 into column "Status" in Table 3
...
New Table 3 looks like this
Identification | date | species | latitude | Longitude | Status |
I need to keep every single rows from each table. How can I do this?
Thanks you.
Solved! Go to Solution.
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"
Hi @shuang,
Agree with rafaelmpsantos.
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your data sample and your desired output so that we could help further on it.
Best Regards,
Cherry
These 2 tables has the same numbers of rows? in each row number of tableA you have in tableB the correspondent value in the same row?
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.
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |