4 Replies Latest reply: Dec 20, 2013 6:23 AM by Stefan Wühl RSS

    Line duplication SQL Select

    Vincent Mecrin



      I'm extracting a table from SQL and the generated table has duplicated lines. The SQL table has no duplicated lines.

      I only running the following script, no table before or after and no join just the database connection before.



      LOAD *;

      SQL SELECT *

      From MDTestDatabase.SAP.ViewItem;


      if i use a ditinct, i have the following results:

      - LOAD Distinct *: no duplication

      - SQL SELECT Distinct *: duplications


      So, duplication is generated by LOAD statement and not SQL query.


      Any idea?