1 Reply Latest reply: May 15, 2012 3:29 AM by Claudia Zwick RSS

    please help to implement logic

    Vipin Mishra

      i have a 10 record and there have a different data

      eg.

      1 - doc

      1 - koc

      1 - noc

      same as 2, 3 ,4 ,5 ,6, 7 ,8,9, 10

       

      if i want to data 1 to 9 all data doc , koc and noc  but in 10 i want to only koc data then how can i implement the logic

        • please help to implement logic

          Hi,

           

          You can do it in the following way:

          Test:
          LOAD * INLINE [
          F1, F2
          1, doc
          1, koc
          1, noc
          2, doc
          2, koc
          2, noc
          3, doc
          3, koc
          3, noc
          4, doc
          4, koc
          4, noc
          ]
          ;


          Test1:
          LOAD
          F1 AS record,
          F2 AS data
          RESIDENT Test
          WHERE F1 <> 4;
          JOIN
          LOAD
          F1 AS record,
          F2 AS data
          RESIDENT Test
          WHERE F1 = 4
          AND F2 = 'doc';


          Regards vicky