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 the second data source .For the sake of simplicity will call them A and B.Including sample data.Table A Sample SoftwareManufacturerVulnerable Manufacturer Found Vulnerable Software found URLbiosdevnameOthers kpartxOthers libXtstOthers hwdataOthers Table B sample Entry IDManufacturerSoftwareVersionTypePlatformDate https://vuldb.com/?id.207465TOTOLINKempty4.1.2cu.5182_B20201026emptyempty08-29-09:20https://vuldb.com/?id.207464TOTOLINKempty4.1.2cu.5185_B20201128emptyempty08-29-09:20https://vuldb.com/?id.207463TOTOLINKempty4.1.2cu.5182_B20201027emptyempty08-29-09:20Vulnerable Software Found and Vulnerable Manufacturer found , are calculated column , which return value from Table B respectively using the following formula : MAXX ( FILTER ( vuldb_id_report_no_version, SEARCH ( vuldb_id_report_no_version[Software], bov_software[Software], 1, 0 ) > 0 ), [Software] ) What i would like to achieve is return the value in the URL column , based on if vulnerable manufacturer or vulnerable software is true. IF (ISBLANK(bov_software[Vulnerable Manufacturer Found] && bov_software[Vulnerable Software found] ), MINX( FILTER ( vuldb_id_report_no_version, SEARCH ( vuldb_id_report_no_version[URL], 1, 0 ) > 0 ), [URL] )) Your help is greatly appreciated

D92 maybe you can try this IF (ISBLANK(bov_software[Vulnerable Manufacturer Found]）) || isblank( bov_software[Vulnerable Software found] )), MINX( FILTER ( vuldb_id_report_no_version, SEARCH ( vuldb_id_report_no_version[URL], 1, 0 ) > 0 ), [URL] ))

ryan_mayu Thank you for the suggestion that did not work.

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

D92 I checked your sample data we don't have the sample value for table A and table B, how can we create the relationship or get value from table B to table A?

ryan_mayu , can the data be extracted from table B to Table A if a value in the calculated columns exist ?

D92

Frequent Visitor

4 years ago

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 the second data source .For the sake of simplicity will call them A and B.Including sample data.

Table A Sample

Software	Manufacturer	Vulnerable Manufacturer Found	Vulnerable Software found	URL
biosdevname	Others
kpartx	Others
libXtst	Others
hwdata	Others

Table B sample

Entry ID	Manufacturer	Software	Version	Type	Platform	Date
https://vuldb.com/?id.207465	TOTOLINK	empty	4.1.2cu.5182_B20201026	empty	empty	08-29-09:20
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

Vulnerable Software Found and Vulnerable Manufacturer found , are calculated column , which return value from Table B respectively using the following formula :

MAXX (
    FILTER ( vuldb_id_report_no_version, SEARCH ( vuldb_id_report_no_version[Software], bov_software[Software], 1, 0 ) > 0 ),
    [Software] 
)

What i would like to achieve is return the value in the URL column , based on if vulnerable manufacturer or vulnerable software is true.

IF (ISBLANK(bov_software[Vulnerable Manufacturer Found] && bov_software[Vulnerable Software found] ),
MINX(
 FILTER ( vuldb_id_report_no_version, SEARCH ( vuldb_id_report_no_version[URL], 1, 0 ) > 0 ),
 [URL]

))

Your help is greatly appreciated

Need Help

Forum Discussion

Lookup Value from another Table

13 Replies

Related content

lookup value in another column

lookup value in another table which matches value in another

Power Query LookUp in another table

Lookup values from another table

Lookup value from another table