I'm trying to use a sub (child) transformation, and then continue to edit the data stream in the parent transformation. Everything works, except I'm not able to pull the resulting columns automatically into any subsequent operator after the Transformation Exectutor (TE). Here's where I'm at:
The child transformation simply pulls some data from a database. The parent transformation calls the child transformation and runs it for several databases (configured in the Data Grid operator). On top of the screenshot I put the configuration of the TE. When I rightclick and "preview" the TE, I get to see correct results. If I add columns in the child transformation, they show properly.
My problem is that I can't seem to get any operator (for example a simple select operator) to populate with the fields provided by the child operator. I read the TE wiki, but I've not been able to to figure it out. My goal is to simply add a "select" operator which populates the field list based on the fields from the child transformation (when clicking "Get fields to select").
I'd really appreciate some help, I've tried "everything" (except the right thing apparently )