Set_Analysis - data types possible for intersection

[#1]

Hi all,

Please consider the below two tables. Please take the highlighted cells of Table 1 and Table 2 as $ and $1 respectively.

Table 1

Col1(Int)	Col2(varchar)
1	A
2	B
3	C
4	D
5	E

Table 2

Col1(Int)	Col2(varchar)
1	E
2	F
3	C
4	G
5	H

Intersection is working fine on col1 with the expression (i.e count({$*$1} col1)

I tried the same for col2 with the expression count({$*$1}col2). But this does not give me any result.

My assumption is intersection can be performed on Int data types. Now i would like to know if an intersection can be performed on the field Col2 i.e varchar so that i would get "3 and C" as my result.

Can anyone help me on this.

Thanks

Hariharan

[#2]

Hi,

try: only({$*$1} Col1) and =only({$*$1} Col2)

this will give you the result expected 3 and C.

Andrea