CODEWITHSUNDEEP
excelpowerquery
Empty Coder
Empty Coder

Reputation: 589

Add column from another table using excel power query

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 by adding Custom Column and #"table-1"[#"Status->name"]{0} in table-2 but the data is not coming as expected please let me know on this

Upvotes: 0

Views: 181

Answers (1)

horseyride
horseyride

Reputation: 21363

Merge the first table and second table with left outer join, then use arrows atop the the new column to expand [x] Status>name field

enter image description here

Upvotes: 2

Related Questions