Forum Discussion
append record from from another table
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 |
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!
1 Reply
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!