Forum Discussion
Lookup Value from another Table
Hi Guys, New to the forum and I would really appreciate some help. I have two data source , with different values, of of the data source contains calculated column to return the values from t...
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 |
Table A contains calculated values for Vulnerable software found and Vulnerable Manufacturer Found based on the following formula :
MAXX (
FILTER ( vuldb_id_report_no_version, SEARCH ( vuldb_id_report_no_version[Software], bov_software[Software], 1, 0 ) > 0 ),
[Software]
)Therefore they are calculated values which are filtered from Table B and A.
What I want to achieve is if they are populated and not blank , get the Entry ID from table B and insert it in Table A .Hope this makes it more clear now.
Tried the bellow formula with no success.
URL = IF(NOT(ISBLANK(bov_software[Vulnerable Manufacturer Found] || bov_software[Vulnerable Software found])),
FILTER(vuldb_id_report_no_version,SEARCH(vuldb_id_report_no_version[URL],vuldb_id_report_no_version[URL]))
)