SOLVED

Power Query - Is it possible to append tables with overlapping data

Copper Contributor

Hi,

 

I am new to this community and was hoping to get some guidance around tackling an situation I am facing.

 

I receive a data in a table format for last 100days every week. I would like to append the tables and create one table from all the files however, I cannot think of a way to active this using power query.

 

I have created rolling 14day data table below as an example.

Table 1

Datedata
1/01/202111
2/01/202186
3/01/202120
4/01/202139
5/01/202121
6/01/202135
7/01/202146
8/01/202158
9/01/202173
10/01/20215
11/01/202171
12/01/202135
13/01/202181
14/01/202144

The next week I would receive a table like below

Datedata
7/01/202194
8/01/202123
9/01/202147
10/01/202170
11/01/202197
12/01/202115
13/01/202177
14/01/202158
15/01/202110
16/01/202143
17/01/202141
18/01/202171
19/01/202196
20/01/202157
21/01/202120

 

So I would like to append the two tables and create a table which contains data for 1-21 Jan, but avoid duplicating 07-14 Jan data, is this possible using power query?

 

Thanks in advance.

 

 

 

5 Replies

@lucioxiii 

 

but avoid duplicating 07-14 Jan data, is this possible using power query?

 

There is no duplicate data in that period - apart from the dates themself.

 

@Detlef Lewin 

 

Thanks for pointing that out. 

 

I have updated the data in the tables.

 

Table 1

Datedata
1/01/202111
2/01/202186
3/01/202120
4/01/202139
5/01/202121
6/01/202135
7/01/202194
8/01/202123
9/01/202147
10/01/202170
11/01/202197
12/01/202115
13/01/202177
14/01/2021

58

 

Table 2

Datedata
7/01/202194
8/01/202123
9/01/202147
10/01/202170
11/01/202197
12/01/202115
13/01/202177
14/01/202158
15/01/202110
16/01/202143
17/01/202141
18/01/202171
19/01/202196
20/01/202157
21/01/202120
best response confirmed by lucioxiii (Copper Contributor)
Solution

@lucioxiii 

After you append one to another, in Power Query editor select both columns 

Home -> Remove Rows -> Remove Duplicates

Thank you. That worked :)
1 best response

Accepted Solutions
best response confirmed by lucioxiii (Copper Contributor)
Solution

@lucioxiii 

After you append one to another, in Power Query editor select both columns 

Home -> Remove Rows -> Remove Duplicates

View solution in original post