5 Replies Latest reply: Mar 29, 2012 2:35 AM by Celambarasan Adhimulam RSS

    interseccion / intersection

      Necesito que me apoyen en el siguiente caso /

      I need your support in the following case:

       

      Tabla A

      Cod
      Nom
      1AA
      2AB
      3AC
      4AD
      5BA
      6BB
      7BC
      8BD

       

      Tabla B

      Cod
      Dat
      2ACV
      3BCT
      5DGT
      6ADD

       

       

      Lo que quiero es poder hacer los siguientes filtros

      Todo = { 1,2,3,4,5,6,7,8 }

      Solo B = { 2,3,5,6 }

      Todo lo que esta en A y no en B = { 1,4,7,8 }

       

      What I want is to do the following filters
      All = { 1,2,3,4,5,6,7,8 }
      Only B = { 2,3,5,6 }
      All that is in A and not B = { 1,4,7,8 }


        • interseccion / intersection
          Perumal Ayyappan

          Hi,

           

          use this script .helpful for u

           

           

           

          tableb:

          Load * inline [

          Cod, Dat

             

          2,    ACV

          3,    BCT

          5,    DGT

          6,    ADD

          ];

           

           

          Load *  where Not exists (Cod);

          TableA:

          Load * Inline [

          Cod, Nom

             

          1,    AA

          2 , AB

          3,    AC

          4,    AD

          5    ,BA

          6,    BB

          7    ,BC

          8    ,BD

          ];

           

          tabA:

          Load Rowno(),* Resident  TableA;

           

          Drop table TableA,tableb

           

           

          Regards

          Perumal A

            • Re: interseccion / intersection

              I have to get the information in Table A and Table B, and then to apply the filters, I need cod and name fields

               

              When you select should show all

               

               

              CodNomDat
              1AA-
              2ABACV
              3ACBCT
              4AD-
              5BADGT
              6BBADD
              7BC-
              8BD-

               

               

              when I select the intersection of Table A and Table B

               

               

              Cod NomDat
              2ABACV
              3ACBCT
              5BADGT
              6BBADD

               

              when I select the data of Table A that are not in the Table B

               

              CodNomDat
              1AA-
              4AD-
              7BA-
              8BD-