merge queries but got more than 1 result

[MiaZhao]

I have 2 tables. One is the contacts the other is the call records. I want to merge these 2 tables to see who called us most.

The problem is when I merge these 2 tables I got more than 1 mapping results. How can I just expand the first mapping result to the current table?

table A

number	call date	duration
123	1-Jan	50s

table B

name	number
A	123
A1	123
A2	123

result

number	call date	duration	expanded row
123	1-Jan	50s	A

[Ashish_Mathur]

Hi,

If there are 3 names against the same number, then you obviously will get moe than 1 mapping record.

[MFelix · Accepted solution]

Hi @MiaZhao,

You are getting more than one result because you have on table B more than 1 line with the match to Table A so when you merge it will get the information from.

I don't know if this works but on table A do a group By and select the number and the aggregator MIN name this will give you only row A then just do the merge with that row.

Regards,

MFelix

[MiaZhao]

Thanks. Brilliant. It is what I want.