Hi @ppr : First loop is having unique records.
It seems issue appeared when processing second loop inside first loop to consolidate values.
I have tried both methods : 1. Join different data tables with unique id 2. Pass required values from second loop and update into first loop as row items during processing of first loop.
Table 1.xlsx (8.6 KB)
Table 2.xlsx (9.0 KB)
Output Data table.xlsx (9.1 KB)