How to make a "keep join" in Power Query Editor?

[AiolosZhao]

Hi all,

I'm new to Power BI, and I want to do a "keep join" in Power Query Editor, for example, what I have is :

Table1:

ID

1

2

3

4

5

6

Table2:

ID	Value
1	10
3	20
3	15
4	30
6	40
6	50
8	60
9	70
10	60

I want to change the Table 2 to: (just based on the table1.id)

ID	Value
1	10
3	20
3	15
4	30
6	40
6	50

How to solve that?

Thanks.

Aiolos Zhao

[AiolosZhao · Accepted solution]

I got the answer, just use right outer join.

[AiolosZhao]

Anyone can help to solve this question?