Loop end - execute failed

[FabioBusca]

I everybody, I have this problem: in a Counting loop, the Loop End fails at the very first row of the first iteration with this warning: "Execute failed: Duplicate key detected: “Row…#38”. This RowID is not in my input table (exist the RowID without ‘#38’), so I cannot address the problem. Can someone help me?

[yogesh_nawale]

Hi @FabioBusca,

I would suggest that you use RowId node.
Before entering the loop, use the “RowID” node to reset the Row IDs of your input data. This will ensure that each row has a unique identifier.

Also in Loop End node configuration, you can choose how to manage RowIds
Specifies how to deal with the RowIDs for each table.

Generate new RowIDs- RowIDs are newly generated (Row0, Row1, …)
Unique RowIDs by appending a suffix - the iteration number is added to each RowID from the incoming table, thus making the RowIDs unique over all iterations
Leave RowIDs unmodified - the incoming RowIDs are not altered. In this case you have to make sure that there are not duplicate RowIDs in different iterations. Otherwise an error occurs.

Regards,
Yogesh

[FabioBusca]

Thanks for your help Yogesh

[yogesh_nawale]

You are welcome @FabioBusca , if you are satisfied with the answer you can mark it as solution. Thanks