Rejoining information after dynamic input tool

[lmbell]

I am trying to "rejoin" information that was previously there after I used the dynamic input tool - please see screen shot. I am using the dynamic input tool (the one with the arrow pointing at it) to replace a string of sql query with a series of new strings (a repetition of "or gpi like '123%' or gpi like '456%' or gpi like '789%') with the 123, 456, 789 being placeholders for longer number strings coming from another column in my worksheet. The dynamic input sql replacement part is working, but now I can't figure out how to get the rest of the columns that were in my original spreadsheet back into the output along with the additional information I have pulled with my replacement sql query. The join in my screenshot is a placeholder... a simple join won't work because my 'or gpi like 123%' query has now returned longer numbers that don't match with my shorter numbers in the spreadsheet. Any advice on what tool might work there?

[CoG]

The best way I know to do that would be to place the Dynamic Input Tool into a batch macro. This way you can join/append the initial data from the macro input to the Dynamic Input's output before finally sending to Macro Output.

[Brankl]

If I understand this right, you're trying to join information from two different dynamic input tools. In theory, any unique column or unique combinations of columns can be used as the join field. Does that make sense, or am I not understanding your question?

[CWG0816]

You can add row numbers to the data set before your dynamic input which then become your join criteria. If the row order has not changed you can join the data based on record position instead of specific field. 

[lmbell · Accepted solution]

CWG0816 that wasn't the solution I needed, BUT when I tried to see if your suggestion would help me, the solution that would have bitten me if it was a snake was right there -- all I had to do was select "Pass a Field to the Output" and select which fields I wanted passed through and it is doing what I need. I am not sure how I missed that while I was trying to figure this out earlier!!