How to show a match of two tabels?

[tappij2012]

Hi,

I'll have two different tabels where I want to find and show a match in one of them.

I'll only want to use an expression.

Example:

Tabel 1:

Header 1	Header 2
1	aaa
2	cac
3	bbb
4	ddd
5	ccc
6	aba

Tabel 2:

Header 1	Header 2	Header 3
1	fff	no match
2	cac	match
3	aaa	match
4	aba	match
5	ggg	no match
6	ccc	match

Header 2 of tabel 1 looks into tabel 2 (Header 2) to find a match.

What is the expression for Header 3 to solve this?

Gr. Tappij

[jolivares]

The way to do that is making a map

tab1map:

mapping

load header1,

       header2

from tab1;

tab2:

load header1,

       header2,

       If(Header2 = Applymap('tab1map',header1),'Match','No Match') as Header3

from tab2;

[#3]

Hi,

Is the solution in attached file what you need?

Regards

http://quickdevtips.blogspot.com/

[tappij2012]

Mabye this is ok, but I don't want to use the script.

It must be in Expression format.

[tappij2012]

Hi,

Thanks, but this is not what I mean.

I've put an attachment as example.

There you see two different tabels. In tabel 2 you see the match of column C with tabel 1 column D.

I'll still want to use an expression in tabel 2 column D.

Regards