Forum Discussion
append queries
Hi Anonymous ,
Anonymous is correct, the fields should have the same name but, just as important, they must be the same CASE.
M code is entirely case-sensitive, so it will see capitalised and non-capitalised field names as completely different words.
I imagine that, while your rows under your original table appear null, you will have a load of new columns to the right with the field names as they appear in your second table which contain the values you're looking for. This is a sure-fire indicator that Power Query is seeing the field names as different values.
For completeness: you must also ensure that your fields to be appended are also the same DATA TYPE, but it doesn't look like this is affecting you.
Pete
Hello Anonymous ,
Could you share some data ?
These are the two tables that i am trying to append
Hello Anonymous ,
I am able to append the data.
Make sure to append the data both tables should have same column name.
Hi Anonymous ,
Anonymous is correct, the fields should have the same name but, just as important, they must be the same CASE.
M code is entirely case-sensitive, so it will see capitalised and non-capitalised field names as completely different words.
I imagine that, while your rows under your original table appear null, you will have a load of new columns to the right with the field names as they appear in your second table which contain the values you're looking for. This is a sure-fire indicator that Power Query is seeing the field names as different values.
For completeness: you must also ensure that your fields to be appended are also the same DATA TYPE, but it doesn't look like this is affecting you.
Pete