Append not working, please help

[dbarseg1]

Hi everyone,

Below shows the columns in our team's mass sales file. It contains all the raw sales data. Let's call it Table A:

Our team made some manual sales adjustments in another file and I now need to append those adjustments to revenue into Table A. This is how the manual adjustments looked, lets call it Table B:

When I tried appending Table B to Table A, it would not actually be appended, meaning none of the adjustments were present, nor were any of the new BRAVO Major or Product Map values. I thought it was because Table B was missing some of the columns from Table A, so I inserted blank custom columns (=" "), duplicated them, and copy pasted the 28 column headers from Table A into Table B. Still, nothing actually appended. I tried changing the format of the columns to match one another but that didn't work either. When I added the appended Table A back into my dashboard, it broke some of the visuals because now some of the existing columns were being read as text instead of values. 

I'm wondering if there is another way for me to incorporate the manual adjustments Table B into Table A. 
Any help is appreciated. Thank you!

[Anonymous · Accepted solution]

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.