Issue related to export merge join keys to exported kettle job.

[KirtiMistry]

Steps to recreate the issue

1) Connect two different database connections (one for source database and second for target database) 2) Drag any 2 tables(tables which are related i.e. have SQLRelationship)from source database connection to playpen. 3) If tables are not related setup relationship using button to create a RelationShip from left panel. 4) Create a new table from the button from the left panel. 5) Create columns (as per requirements) (e.g at least 2 or 3 new columns)

6) Right click on newly created column and select "Column Properties.." option and click on "source for ETL mapping" button" to map form source tables in your playpen.

7) Make sure that the new column must have the same datatype as the mapped column. 8) Click on ETL > Create Kettle Job option in menu. 9) Select Target Database 10) Select 'Save a job to File' option and specify the path where you want to save the job. and click on OK.

This will create the kettle job at specified location.

Go to Pentaho open the job that you just created.

11) Right click on your output table( e.g std_detail2) click on 'Open Referenced Object' > 'Transformation;

12) This will open Transformation for your output table (e.g std_detail2). double click on merge join as shown in below image.

You will see Kets for step1 and 'keys for step2' missing.

The expected behaviour should be: Keys for 1st step should be the (primary key from your First Step ( e.g Student Table) Keys for 2nd step should be the (Foreign key from your second Step ( e.g address2Table)

Expected output should be as below:

[vinodgopu]

Tested in new build, joining key gets populated as expected