Append query - extra column appear

[bbbbi01]

Hi,

I am having a problem with appending queries. 

I have 4 tables that I imported from excel. I want to combine all the tables and have them as one table. The attributes inside each table are year, state, sales and so on. In the new table, i was supposed to have 5 columns but I found i had 6. The extra column appeared as Sales, but showing null in each cell. 

I really don't know where the mistake is. I checked the original 4 tables and the 5 columns. Nothing wrong. Does anyone know what happened?

Thanks!

[Fowmy]

@bbbbi01 

Power Query is case sensitive make sure your column names in all tables are the same, I see "sales" and "Sales". S is capital in one and not in the other.

[wini_R]

Hi @bbbbi01,

It sounds like one of the Sales columns has different name than the others, ie. it includes some invisible character at the end of the name, etc. Please make sure it's not the case and append tables again.

[Daniel29195 · Accepted solution]

@bbbbi01 

make sure that all the columns for all the excels are named the same and make sure also that the data type of columns for all excels are the same,

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[bbbbi01]

Thank you! I chekced what you mentioned and it finally worked out!