Append Tables Issue

[Chanleakna123]

Hi All , 

I have few issues with Append work , 

Row Number 7 is the new table to append inRdong Table , 
It shows null text while create another Column RM Code at the right hand size. Actually in Rdong table , RM code stays in the first column already. the Column of each tables are matched. 

Can you please assisst me on this case ? 

Thanks with Best Regards, 
Leakna Hang 

[v-qiuyu-msft · Accepted solution]

Hi @Chanleakna123,

From the screenshot, the most left column is named RM Code, while the most right column is RM COde. In Query Editor, it's case sensitive. So when you append queries, column RM Code and column RM COde are treated as different columns. 

You can modify the column name RM COde to RM Code then append again. 

Best Regards,
Qiuyun Yu