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.
Hi all,
I have two tables
How can i append record from Interview registration to Interview round table?
Final result:
Interview Registration Data:
Registration Date | Candidate ID | Name | Address | Phone | Experience | Department | |
1/1/2019 | C1 | A | XXXX | XDE | 987654 | 2 | kkk |
1/1/2019 | C2 | B | XX | KLMJ | 3456 | 1 | LMN |
1/2/2019 | C3 | C | XXX | mnMJ | 356 | 4 | JL |
1/2/2019 | C4 | D | XXXCC | lMJ | 632 | 5 | JL |
Interview Round Data:
Interview Date | Candidate ID | Round | Interviewer | Result |
1/1/2019 | C1 | Tech1 | KL | Selected |
1/2/2019 | C1 | Tech2 | ML | Selected |
1/3/2019 | C1 | HR | KJL | Selected |
1/4/2019 | C1 | Final | AAA | Selected |
1/2/2019 | C2 | Tech1 | KL | Selected |
1/2/2019 | C2 | Tech2 | ML | Hold |
1/3/2019 | C3 | Tech1 | KL | Select |
1/4/2019 | C3 | Tech2 | ML | Rejected |
Solved! Go to Solution.
Hi @Anonymous,
You can do that in PowerQuery (M):
1. Go to Edit Queries -> Edit Queries. Power Query Editor will be opened.
2. You need to give exactly the same names for the columns which you need to be appended by.
For instance, your table Interview Registration Data has a column Registration Date and another table Interview Round Data has a column Interview Date. Just rename Registration Date to Interview Date.
3. Go to Home -> Append Queries -> Append Queries as New -> Select two tables you want to append -> Press OK.
Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
Hi @Anonymous,
You can do that in PowerQuery (M):
1. Go to Edit Queries -> Edit Queries. Power Query Editor will be opened.
2. You need to give exactly the same names for the columns which you need to be appended by.
For instance, your table Interview Registration Data has a column Registration Date and another table Interview Round Data has a column Interview Date. Just rename Registration Date to Interview Date.
3. Go to Home -> Append Queries -> Append Queries as New -> Select two tables you want to append -> Press OK.
Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
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 |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |