Forum Discussion
Append not working, please help
Hi dbarseg1 ,
As far as I know, Power Query performs the append operation based on the names of the column headers found on both tables, and not based on their relative position in the headers sections of their respective tables.
If one table doesn't have columns found in another table, null values appear in the corresponding column.
Append queries - Power Query | Microsoft Learn
You can check if the corresponding column names are the same in both tables (to prevent blank values before and after the column names or inconsistent case of the column names), because sometimes it creates new columns if there is a small difference in the column names
Solved: Append Query Not Working Properly - Microsoft Fabric Community
Solved: Issue with append queries - Microsoft Fabric Community
You can check if the text column after append operation is in text format in another table, because both types of data (numeric and text) are automatically displayed in text format without any data change after append operation.
Can you share your append merge operation? We can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dbarseg1 ,
As far as I know, Power Query performs the append operation based on the names of the column headers found on both tables, and not based on their relative position in the headers sections of their respective tables.
If one table doesn't have columns found in another table, null values appear in the corresponding column.
Append queries - Power Query | Microsoft Learn
You can check if the corresponding column names are the same in both tables (to prevent blank values before and after the column names or inconsistent case of the column names), because sometimes it creates new columns if there is a small difference in the column names
Solved: Append Query Not Working Properly - Microsoft Fabric Community
Solved: Issue with append queries - Microsoft Fabric Community
You can check if the text column after append operation is in text format in another table, because both types of data (numeric and text) are automatically displayed in text format without any data change after append operation.
Can you share your append merge operation? We can help you better!
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.