This works! Thank you!!!
It is a bit slow, but think it will be fine. There are about 100k rows in each pipeline.
So, _tableName → the underscore means what, exactly?
It has to be a pipeline parameter, right? How does the Execute Pipeline snap “know” to take only one value from the $tableName column?
Correct, _tableName is a pipeline parameter.
The Pipeline Execute Snap takes the $tableName field of each document it receives at the input view, and passes it to the child pipeline as the tableName pipeline parameter.
One thing to note that I may have inadvertently omitted. If you are certain that all of the documents that will show up on the input view of the Pipeline Execute Snap will have the same value for $tableName, you can check the Reuse checkbox in the settings for the Pipeline Execute Snap.
That way all of the documents will be sent to the same instance of the child pipeline, which will immensely improve the execution time. Perhaps it was obvious from your description of the problem, but nonetheless, I put it to you now.
BR,
Dimitri
