Set_Analysis - data types possible for intersection
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.
