Forum Discussion
Lookup Value from another Table
could you pls provide the new sample data and the expected output?
based on the sample data you provided, i can't get the result since we can't use software to find the related info in table B
ryan_mayu my post are getting deleted when I try to paste the sample.
I would like to have the calculated column in Table A URL , obtain the information from Table B Entry ID only if value in Vulnerable Software Found or Vulnerable Manufacturer Found is populated.
Example from the expected outcome.
| Software | Manufacturer | Vulnerable Manufacturer Found | Vulnerable Software Found | URL |
| Microsoft Silverlight | Microsoft Corporation | Microsoft Silverlight | Microsoft Corporation | https://vuldb.com/?id.207623 |
pls try if lookupvalue works for you
LOOKUPVALUE function (DAX) - DAX | Microsoft Docs
LOOKUPVALUE(
TableB[URL],
TableB [vunlerable manufacuturer Found].
TableA [vunlerable manufacuturer Found].
TableB [Vulnerable Souftware Found].Table A[[Vulnerable Souftware Found])
Not sure if this was your suggestion , here is what i have tried which did not return any value.
URL = LOOKUPVALUE(vuldb_id_report_no_version[URL], vuldb_id_report_no_version[Manufacturer],bov_software[Vulnerable Manufacturer Found],vuldb_id_report_no_version[Software],bov_software[Vulnerable Software found] )Table A Sample
Software Manufacturer Vulnerable Manufacturer Found Vulnerable Software Found URL Microsoft Silverlight Microsoft Corporation Realtek High Definition Audio Driver Realtek Semiconductor Corp. Update for Windows 10 for x64-based Systems (KB4023057) Microsoft Corporation Microsoft Update Health Tools Microsoft Corporation Grammarly for Windows Others Microsoft Azure Information Protection Microsoft Corporation Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.4974 Microsoft Corporation Microsoft SQL Server 2008 R2 Management Objects Microsoft Corporation Enterprise Communicator CA GNOME CORBA ORB and component framework Oracle Corporation Xmanager 6 NetSarang Computer, Inc. JDK 8.0 64-bit Runtime Env. (1.8.0_311) Oracle America, Inc Microsoft Edge Microsoft Corporation Nessus Agent (x64) Tenable, Inc. Oracle - OraClient19Home1 Others Oracle - OraClient11g 11.2.0 Others Table B sample
Entry ID Manufacturer Software Version Type Platform Date https://vuldb.com/?id.207464 TOTOLINK empty 4.1.2cu.5185_B20201128 empty empty 08-29-09:20 https://vuldb.com/?id.207463 TOTOLINK empty 4.1.2cu.5182_B20201027 empty empty 08-29-09:20 https://vuldb.com/?id.207462 TOTOLINK empty 4.3.0cu.7647_B20210106 empty empty 08-29-09:20 https://vuldb.com/?id.207461 TOTOLINK empty 4.1.2cu.5204_B20210112 empty empty 08-29-09:20 https://vuldb.com/?id.207460 TOTOLINK empty 4.1.2cu.5137_B20200730 empty empty 08-29-09:21 https://vuldb.com/?id.207459 TOTOLINK empty 4.1.5cu.532_B20210610 empty empty 08-29-09:21 let's clarify the logic
This is the first row of table A
Software Manufacturer Vulnerable Manufacturer Found Vulnerable Software Found URL Microsoft Silverlight Microsoft Corporation How do you want to get the value for the last 3 columns from Table B?
in my opinion, based on the sample data you provided, we can't get the expected output below.
Software Manufacturer Vulnerable Manufacturer Found Vulnerable Software Found URL Microsoft Silverlight Microsoft Corporation Microsoft Silverlight Microsoft Corporation https://vuldb.com/?id.207623