etlkettlepentaho-spoonspoon

Spoon lookup obtaining two rows instead of duplicate columns


I have this two tables

enter image description here

If I use the lookup step using the EMPLOYEEID and YEAR I get this columns:

enter image description here

But I need to get this instead:

enter image description here


Solution

  • I have prepare a solution Here. Using this you will get your result.

    Please let me know if its ok with you.