AnsweredAssumed Answered

Problems passing parameters to a trasformation step

Question asked by Rafa Flores on Jun 22, 2018
Latest reply on Jul 16, 2018 by Brandon Jackson


Hi all,

 

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:

 

org;product

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 8.1.0.0-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!

Best,

 

Rafa

Outcomes