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?
