Kettle transformation with muli input streams -
i have 2 files single fields. looks like:
file file b a1 b1 a2 b2 a3 b3 a4 b4
i have a1,b1; a2,b2 when connect 2 inputs transformation kettle says inputs have different layouts
you don't have details of transformation, guess picked 'append streams' step. should use merge join step , 2 'add sequence' step add line nr input (set different counter name both steps). connect 2 'add sequence' steps 'merge join' step configure key fields line number , set join type to: 'full outer'. next can use select values step rid of line number columns.
Comments
Post a Comment