Forum Discussion
Power Query - Append columns
jennratten - Thank you making me learn. I tried creating an example and replicated the interview question in the power query . what i got was - It created 2 columns seperately instead of appending and creating/ considering as a single column it created 2 columns (Merchant Country and MerchantCountry ) where MerchantCountry has NULL's .
Super UserGreat - Were you able to transform the data so that the two tables appended as expected instead of separately?
I did renamed the column by removing the space and then appended then it worked .
please let me know if you have any other transformation other than this . Thanks
Hi naveenskyline ,
To combine columns from two tables in Power Query,
if the column names are different,
you need to make the names the same first.
You did it right by renaming the column to remove the space.
This is the simplest way to make sure the columns from both tables come together as one when you append them.
Chiranjeevi Kudupudi