英文:
Add column from another table using excel power query
问题
以下是您要翻译的内容：
"Instance Full Name" 和 "Full Name" 根据 "Instance Full Name" 和 "Full Name" 从 "table-2" 中获取 "Status->name"
"期望的结果"：
Instance Full Name Full Name Status->nameDB-ODIPRD ODIPRD In Production
我尝试通过在 "table-2" 中添加 "自定义列" 和 "#"table-1"[#"Status->name"]{0}"，但数据没有按预期显示，请告诉我如何处理这个问题。
英文:
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 SupportXXXXX 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.2ODIPRD 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->nameDB-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
答案1
得分: 2
使用左外连接合并第一张表和第二张表，然后在新列上使用箭头来展开[x] Status>name字段。
英文:
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
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论