The usual join does not seem to work, it will create cross join. so I think I would need to implement iterative macro.
I cannot aggregate the inputs and then join, as it will not retain the details.
I believe I need to iterative through the input-1 and input-2 as well. (also another complication level that I need two types of join, may be it can be two iterative macros)
The results will always have same number of rows as the input-1.
the input-1 and input-2 are joined based on Request ID , Tracking and Model. But if that join does not work then next alterative join is only based on Tracking and Model.
I have give two examples to explain how the results would look like.
the results will have same columns as input columns + the Serial # column from input-2
