Magic ETL allow more than 10,000 duplicates on Joins

Magic ETL does not allow more than 10,000 duplicates on columns used for Joins.


This is severely limiting for us non SQL users (its not hard to have 10,000 duplicates on a 1.2 million row DataSet).

I currently get by (but still cannot do everything I want) using the lookup function on the Workbech but even that is limited in several other ways and it adds more and more layers of complications and they can only be done by the WB user.


Please remove the limit and allow unlimited duplicates.

1 votes

· Last Updated


  • btm



    Thank you for submitting this @rado98. I am assigning to our product manager @StevenC to review and comment.

  • @rado98 Thanks for sending in this great  suggestion for Magic.  This has been added of improvements that we should consider as we continue to build out and improve Magic.  I am glad that you are using the product, and want it to become better.  Great Suggestion!

This discussion has been closed.