Dynamic Input Tool with 2 data sources

[cutehappybear]

Hello,

I have dynamic inputs tools, with a sql query where I then replace a specific string by a variable. I want to do the same thing, but replace 2 strings with 2 variables.

For example: SELECT (...) WHERE Field IN ('field') AND Value IN ('value').

Then, I replace field by a concatenation of strings, and I replace value by a concatenation of numbers.

How can I get both of these concatenated variables to the dynamic input tool?

I have 2 Summarize tools where I do the concatenation, but then I can only connect one of them to the dynamic input tools.

[RolandSchubert · Accepted solution]

Hi @cutehappybear ,

have you considered to use an Append Fields tool (if the same string has to be use for all rows from the first summarize tool) or a Join tool (if there is any key field to connect the rows from both Summarize tools?

Could that be an approach?

Best,

Roland

[cutehappybear]

Thank you very much! I managed to use the Join tool 😊