Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear All,
I have a table called 'Record ID' which has distinct list of record ids and then i have a 'Details' table which has various details related to that record id. One record ID might have multiple values in another table. Example as below -
Table 1 :
Record ID | Opportunity Name | Account Name | Opportunity Owner |
0064G000013rD6mQAE | Abhyudaya Co-Operative Bank-IT/PO-16/2017-18-40085308-10-$69 | Abhyudaya Co-operative Bank Ltd | Vinod Iyer |
0064G000013snC6QAI | Abhyudaya Bank - Nexus Switches and FW Case | Abhyudaya Co-operative Bank Ltd | Amey Khochare |
0064G000013tHYtQAM | Cisco-Accenture-GGN--Sheetal(DCCOR & others) | Accenture Services India Pvt. Ltd. | Seshasai Vaddadi |
0064G000013rmYiQAI | Adobe_Bangalore PTC Expansion | Adobe | Raghvendra Singh |
0064G0000136tlJQAQ | Remote office | Airbus | Mudit Shinghal |
0064G0000136tlJQAQ | Remote office | Airbus | Mudit Shinghal |
0064G000013qkE3QAI | Riverbed appliance | Airbus | Mudit Shinghal |
0064G000012C2OJQA0 | uDNS AMC Renewal | Airtel | Komal Grover |
0064G000014qiEkQAI | ASR 5G expansion | Airtel | Komal Grover |
0064G000014rAlSQAU | uDNS AMC-2 | Airtel | Komal Grover |
Table 2
Record ID | Vertical | Region-NEW | BU | SU | Original Close Date |
0064G000013rD6mQAE | ENT | West | DI | SS | 4/26/2020 |
0064G000013snC6QAI | ENT | West | DI | Product | 4/24/2020 |
0064G000013snC6QAI | ENT | West | SEC | Product | 4/24/2020 |
0064G000013tHYtQAM | ITES | South-1 | DI | Training | 4/30/2020 |
0064G000013rmYiQAI | ITES | North | DI | Product | 4/27/2020 |
0064G0000136tlJQAQ | Globals | South-1 | DI | Product | 4/16/2020 |
0064G0000136tlJQAQ | Globals | South-1 | DI | SS | 4/16/2020 |
0064G000013qkE3QAI | Globals | South-1 | DI | Product | 4/30/2020 |
0064G000012C2OJQA0 | M&C | North | SEC | SS | 4/17/2020 |
0064G000014qiEkQAI | M&C | North | DI | Product | 4/22/2020 |
0064G000014rAlSQAU | M&C | North | SEC | SS | 4/22/2020 |
0064G000013rD6nQAE | ENT | West | DW | SS | 4/30/2020 |
0064G000013qzr9QAA | ENT | South-1 | DI | Product | 4/27/2020
|
Now i need to update Table 1 with values from Table 2. And i need to ensure that, were ever we have multiple values for one 'Record ID' they should appear as well. In the above example record id 0064G000013snC6QAI has 2 BUs in table 2 called DI & SEC so in table 1 i should have 2 rows one for DI and another one for SU and rest of the values can remain same. It should look like this :
Record ID | Opportunity Name | Account Name | Opportunity Owner | Vertical | Region-NEW | BU | SU | Original Close Date |
0064G000013snC6QAI | Abhyudaya Bank - Nexus Switches and FW Case | Abhyudaya Co-operative Bank Ltd | Amey Khochare | ENT | West | DI | Product | 4/24/2020 |
0064G000013snC6QAI | Abhyudaya Bank - Nexus Switches and FW Case | Abhyudaya Co-operative Bank Ltd | Amey Khochare | ENT | West | SEC | Product | 4/24/2020 |
I can't merge or append query as few coulmns in the table have been created using "LOOKUP" function.
Regards,
Krishna
Hi @KRISH80 ,
Try to create a many to many relationship and set the filtering direction to single.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |