1 Reply Latest reply: Sep 18, 2015 5:21 AM by Manish Kachhia RSS

    how to load necessary data only?

    Jim Chan

      hi there,

       

      i have 2 tables. table 1 has 606 rows of data. table 2 i have 32 rows of data.

       

      i only need necessary data from table - which are only 32 rows, the rest i dont need.

       

      so. how can i load table 1 , in such a way that , it will load out the necessary data 32 rows , instead of 606.?

        • Re: how to load necessary data only?
          Manish Kachhia

          Table2:

          Load * From Table2;

           

          Table1:

          Load * From Table1

          Where Exists(CommonFieldBetweenBothTable);

           

          Example:

          T2:

          Load * Inline

          [

            Customer

            A

            B

            C

            D

          ];

           

           

          T1:

          Load * Inline

          [

            Customer, Sales

            A, 100

            B, 200

            C, 300

            D, 400

            E, 500

          ] Where Exists(Customer);

           

          The above script will not load Customer E Data..