1 Reply Latest reply: Oct 2, 2017 12:35 PM by Stefan Wühl RSS

    how to eliminate duplicate values from while loading

    vinod k

      Hi

       

      can we eliminate duplicate values from while loading its self. please let me know.

       

      Regards,

      Vinod

        • Re: how to eliminate duplicate values from while loading
          Stefan Wühl

          Can you be a bit more specific about your issue and the requested outcome?

           

          To eliminate duplicate records, you can use a distinct load:

           

           

          LOAD DISTINCT

               FieldA,

               FieldB,

          ...

          FROM ...;

           

          To only load the first record in load order for a specific non-key field value:

           

          LOAD

               FieldA,

               FieldB,

          ...

          FROM ...

          WHERE NOT EXISTS(FieldA);

           

          edit: or maybe something completely different depending on your requirements