Append Query Not Working Properly

[Anonymous]

Hi, I am trying to append these three example tables using Append Queries and it appears there's an issue as PBI is not appending all StoreID's into the same column.

Table 1

StoreID	Salesperson	Date	Company
10	GWA	5/6/2019	LLC
21	JNJ	5/7/2019	LLC
10	GWA	5/6/2019	LLC
59	OPI	5/8/2019	LLC

Table 2

Salesperson	StoreID	Date
TYI	10	5/8/2019
OGI	59	5/9/2019
OPI	23	5/7/2019
REW	10	5/3/2019

Table 3

Date	Salesperson	StoreId
5/3/2019	GWA	10
5/4/2019	HIO	55
5/6/2019	CIO	10

I should mention that I manually entered the data in PBI, it is not file upload or query so the data format is date, string and integer in all three cases.

This is the result I get when I append these three tables.

StoreID	Salesperson	Date	Company	StoreId
10	GWA	5/6/2019	LLC	null
21	JNJ	5/7/2019	LLC	null
10	GWA	5/6/2019	LLC	null
59	OPI	5/8/2019	LLC	null
10	TYI	5/8/2019	null	null
59	OGI	5/9/2019	null	null
23	OPI	5/7/2019	null	null
10	REW	5/3/2019	null	null
null	GWA	5/3/2019	null	10
null	HIO	5/4/2019	null	55
null	CIO	5/6/2019	null	10

In the last three rows, the StoreID values should be in column 1 not column 5. Also, column 5 shouldn't even be there since the StoreID (column 5) is StoreID from column 1. The data format is the same and the column name is the same.

Please help! I need to apply this logic on much larger datasets asap.

Thank you!

[Anonymous]

I also looked at some other posts that suggested creating duplicate tables and creating the same order of columns and removing unwanted columns before appending the datasets. I did this and the append still didn't append the data correctly.

[Anonymous]

Here is a screenshot with StoreID data type

[Anonymous · Accepted solution]

Disregard my previous messages. I just realized that I had two versions of the StoreId column name. One as StoreID and other as StoreId. This has been causing the wrong append.