Data Append power query with a common column

New Contributor

Hello Everyone,


I am using power query to combine data from various excel workbook. It was successful when i append the data. I have a common column in each sheets which i have combined. 


How can i give relationship to column and append the data.



1 Reply



Can you share the file/sheets you are trying to do an append query?