Hello friends, I have a problem! I am extracting a series of data from a series of tables in SQL Server through the DB joiner node and when I give the output of these nodes to another DB joiner node, my data doubles (i.e. if I have 500 rows of data, the output of the second node will be 1000 rows, of which 500 rows are duplicated). I have checked in various ways and I know exactly that the problem is with the DB joiner node, but I cannot solve the problem!
My design is such that in the first DB joiner node, it participates and in the second DB joiner node, it checks and presents the output based on the left table
Please guide me! I will upload a picture of my workflow below so that you can guide me.
Hello @alex1368,
It is really challenging to pinpoint the exact issue without much details, but my guess is that there are duplicates in the columns being used for the join conditions.
Could you please filter and share the data from these columns used for join to investigate further?
Best,
Keerthan
3 Likes