I am having problems with PDI when I try to pass result rows from one transformation to another using Parameters/Variables.
I attach you the files, cause I can't figure it out what is wrong with it.
I've been searching for a solution for the last three days with no success so I am a little bit frustrated hehehe
Explanation of the desired solution:
1.- We have a Job that execute 2 transformations
2.- The first one "genera_prod_org" copies rows to result (this rows are a constant)
EXAMPLEA | ONE
EXAMPLEA | TWO
EXAMPLEA | THREE
EXAMPLEB | ONE
EXAMPLEB | TWO
EXAMPLEB | THREE
3.- The job execute the next step as many times as rows are generated from the previous transformation, so the first time we will pass "EXAMPLEA | ONE", the next time "EXAMPLEA | TWO" and so on.
4.- Inside the second transformation "write_vars2textfile" we get the variables and write them into a text file, to have something like:
EXAMPLEA ; ONE
EXAMPLEA ; TWO
EXAMPLEA ; THREE
EXAMPLEB ; ONE
EXAMPLEB ; TWO
EXAMPLEB ; THREE
The problem is that those values: "EXAMPLEA | ONE", "EXAMPLEA | TWO"... are never passed to the transformation, so it always writes the default values in it.
I am running PDI 18.104.22.168-365 with:
$ java -version
java version "1.8.0_171"
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
Thanks in advance!