1 Reply Latest reply: Jun 22, 2011 12:19 PM by danielato.a RSS

    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)
      1A
      2B
      3C
      4D
      5E

       

      Table 2

       

       

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

       

       

      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