Append 2 tables and then rid of duplicates

[Hopeisgood1]

Hi I have an Incidents table that needs to be appended in INC table and then remove the duplicates. I tried several steps and I am not doing this right 🙄 Incidents table has a little over 12K rows and I am not sure if that is an issue or what?

[Uzi2019 · Accepted solution]

Hi @Hopeisgood1 

For append opertion you need to have
1)same number of column and 
2)the sequence of column should be name and
3)Column names should be same 

4)Data type should be same

Then only appned will perform correctly.

chec this video for append query

https://www.youtube.com/watch?v=1cPtk-8iK0k

Issue with remove duplicate check this video

https://www.youtube.com/watch?v=VvsQrlOHHWQ 

I hope I answered your question!

[Hopeisgood1]

Thank you - there was an apparent issue with one of the columns that was blocking the append. Fixed that and it's all good now. 

[vicky_]

The options for append queries and remove duplicates are both in the header under "Home". Tables of 12k or so should not be an issue for Power Query to handle, provided that you have got a reasonable number of columns. 

[Hopeisgood1]

Thank you - there was an apparent issue with one of the columns that was blocking the appending. Fixed it.