Add column from another table using excel power query

Question

I am having below 2 table in excel

table-1

Organization    Server name Contract    OS Type Server Category Server Type Server Status   DB Instance Status  Environment CPU Cores   Instance Full Name  DB Instance name    DB Software name    Version Edition DB Instance size (GB)   DB datasize (GB)    CG Support
XXXXX XXXXXX    SV021   021             Linux   Virtual_System  Virtual Machine In Production   In Production   Production  1   8   DB-ODIPRD   ODIPRD  Oracle Database Server  Oracle-12.1.0.2.0   Standard    733.21  670.43  Yes

and table-2

Full name   Status->name    Product category->name  Software item->Smtc product catalog id type Managed by provider Collected date  Description.1   Description.2
ODIPRD      In Production   DB  Oracle Database Server  Yes 21-02-2023  Oracle-12.1.0.2.0   Standard

Based on the Instance Full Name and Full Name need to get the Status->name from table-2

Expected

Instance Full Name              Full Name         Status->name
DB-ODIPRD                       ODIPRD            In Production

I tried adding Custom Column and #"table-1"[#"Status->name"]{0} in table-2 but the data is not coming as expected please let me know about this

Answer 1

Use a left outer join to combine the first and second tables, and then utilise the arrows on top of the new column to expand [x]. Status field: name