Add column from another table using excel power query

0 votes

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

Feb 24, 2023 in Others by Kithuzzz
• 38,000 points
1,288 views

1 answer to this question.

0 votes

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

enter image description here

answered Feb 24, 2023 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Stop power query from loading to excel sheet

You can just delete the worksheets created ...READ MORE

answered Dec 17, 2022 in Others by narikkadan
• 63,600 points
5,349 views
0 votes
1 answer

How do you populate a google sheets/excel column with cells from a column in another sheet in the same document?

You have two options on chronology: sheet-by-sheet =QUERY({Sheet1!X:Z; Sheet2!X:Z; ...READ MORE

answered Dec 19, 2022 in Others by narikkadan
• 63,600 points
1,628 views
0 votes
1 answer

How to add column filters to Excel worksheet using XLWINGS?

Call the API property to activate the autofilter: import xlwings ...READ MORE

answered Dec 23, 2022 in Others by narikkadan
• 63,600 points
2,332 views
0 votes
1 answer

How can I verify if a column is only decimal using Power Query M formula?

Try this: = Table.ReplaceValue(#"Changed Type",each [Column4], each ...READ MORE

answered Feb 13, 2023 in Others by narikkadan
• 63,600 points
998 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,284 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

answered Dec 12, 2018 in Power BI by Upasana
• 8,620 points
8,840 views
0 votes
1 answer

Power Query : Adding Columns and Multiple files

The following call, FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) shall replace the ...READ MORE

answered Feb 14, 2019 in Power BI by Upasana
• 8,620 points
1,731 views
0 votes
1 answer

Power Query : making HTTP POST request with form data

Try Using Uri.BuildQueryString and Json.Document let ...READ MORE

answered Feb 14, 2019 in Power BI by Upasana
• 8,620 points
6,133 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 63,600 points
806 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP