Match data from two tables

[#1]

Hello.

Would very much appreciate help with comparing data in two tables.

Table 1 (data in this table is static)

Table1
Green
Red
Yellow

Table 2 (data from this table is non static)

Table2
Red
Green

The result I'm looking for after comparing these tables would then look like this

Table1	Data_check
Green	Yes
Red	Yes
Yellow	No

Best Regards

Malte

[#2]

Sorry for late reply. It was what I was looking for. Thanks again

[#3]

Great response Miguel...this helped me as well

Cheers,

Byron

[farolito20]

but if are more than two fields, how execute exist function?

[#5]

Hi Miguel, 

I am having data extracted from SQL table and I am matching it with an inline table to get a field.

But the null data is not coming in the chart. Please help me on this.

Below is my inline table

Start:

ADD LOAD * Inline [_HW_Code, _SW, _SW Name, _BUSINESS, _Domain, _SW Domain Desc, _L1, _L2

BB, RR, Services, Support, <NULL>, <NULL>, Services, Services
 

<NULL>, <NULL>, Others, Others, Others, Others, Others, Others

] ; 

Below is my Dimension expression in sparkline chart

=if(HW=_HW_Code,if(Match([_L1],'Segment','Services','Software','Engineering','Technology','Support')>0,[_L1],'Others')
,If(IsNull(_HW_Code),'Others'))

Note:

'Supress when value is null' is NOT ticked, nor is 'Supress zero-values' or 'Supress Missing'.