I have duplicates in my table, what might have gone wrong?
Question Description:Answer:
Start from the OUTPUT table where the duplicates occur and move backwards node by node to identify in which node the duplicates are created. You can do this by checking the row numbers of INPUT preview and OUTPUT preview of each node.
Usually, duplicates are created in JOINS when you have duplicated values in the JOIN key. To ensure that the granularity of your tables stays remained, make sure that for example in your LEFT JOIN the right table does not have any duplicates in the JOIN KEY column.
Was this article helpful?