6 Replies Latest reply: Jul 26, 2016 7:45 AM by Sunny Talwar RSS

    how to avoid dupilcate

    Naveen N

      TABLE1:

      LOAD *INLINE [

          F1, F2

          1, a

          2, b

          3, c

          4,d

      ];

       

      consider this is the script which is already loaded

      now i am loading this script

       

       

      Concatenate(TABLE1)

      LOAD * INLINE [

          F1, F2

          4, e

          5, f

      ]

      ;

       

      when i am concatenateing i will get data as

       

      F1,F2

      1,a

      2,b

      3,c

      4,d

      4,e

      5,f

       

       

      but my output should be like this

       

       

      F1,F2

      1,a

      2,b

      3,c

      4,e

      5,f

       

      c