Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
try: only({$*$1} Col1) and =only({$*$1} Col2)
this will give you the result expected 3 and C.
Andrea