Unable to join data from two different Excel files?

[Sisay_Dinku (Sisay YDG)]

Hi team,

I have these two excel files downloaded from an application -

I have to read each of them and join on Address and Address Number Columns. And eventually populate the rows that have common Address and Address Number into another data table. I have attempted multiple options and excel format looks like different and makes the join tricky -

Can anyone help with this?
EXPORT_VID 1.XLSX (10.0 KB)
ExpectedResult_Joins.XLSX (10.0 KB)
EXPORT_ADDR 1.XLSX (10.1 KB)

[Yoichi]

Hi,

How about the following?

Sample
Sample20250626-2.zip (25.7 KB)

Regards,

[Sisay_Dinku (Sisay YDG)]

Hi @Yoichi Great. Thank you!