Can someone help me with Iterative Macro, Two input iterative

[amruta]

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

[PangHC · Accepted solution]

it can be done by identify the repeat of the join-key. where Tile Tool is good to use in this case. (or RecordID Tool with groupby for 2024.2 onward)

then just add this SubID in the Join will do the result.

Tool Config Detail

Spoiler

Tile Tool (no GroupBy)


JoinTool

[amruta]

@PangHC This is perfect, thank you so much for posting the solution. I had not used the Tile tool in the past, it seems to do the job!