Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community..!!
I want to merge two columns in such away that table2 data should come below to the table1 data
Table1
Table2
In New merged column ,I should get only 2 columns as a result.
Thanks in advance..!!
Solved! Go to Solution.
@ppatil , For achieving this in power query you have to first rename column name of your table 2 and make it same as table 1 then follow what @David-Ganor has suggested. You will get 2 column only.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @David-Ganor
If I use append then its creating four columns , that I dont want.
Result should comes in 2 coulmns only.
U can read my first question carefully for better understanding.
@ppatil you can change the column names to be the same,
for example:
Team name, Team initial.
If you'd like to distinguish between those tables afterwards (home vs away), please create an additional column for each - something like "source table" where the value should be constant "home" for table 1 , and "away" for table 2
@ppatil , For achieving this in power query you have to first rename column name of your table 2 and make it same as table 1 then follow what @David-Ganor has suggested. You will get 2 column only.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
122 | |
109 | |
97 | |
60 | |
57 |
User | Count |
---|---|
138 | |
116 | |
102 | |
70 | |
57 |