Left Join in power query

When we do Table A LEFT JOIN Table B, the no. of rows in Table A should remain unchanged, correct? Since we are just adding columns and not rows while performing join.
But is there any case in which the no. of rows in Table A will increase?

Hi @Anu,

Here’s a visual aid, illustrating join types.


.

or read a full article here

1 Like

I completely understand this, but my doubt is , Is there any case in which the no. of rows in Table A will increase?

Yes. If there are duplicate keys in Table B, then there will be multiple rows in the joined table. You will only get the exact same number of rows as are in Table A if there is only one (or none) matching record in Table B.
Greg

3 Likes

if you are matching columns that have a duplicate in table B, you can end up with extra rows:

image

3 Likes