This post is written based on a thread from community forum .
(http://forums.pentaho.com/showthread.php?187160-Identify-duplicate-column-value-from-single-row)
USE CASE :
EXPECTED OUTPUT
Transformation Design :
Sample KTR file download : Click HERE
References :
1) http://wiki.pentaho.com/display/EAI/Row+Normaliser
2) http://wiki.pentaho.com/display/EAI/Row+denormaliser
3) http://rpbouman.blogspot.in/2012/03/generic-normalizer-step-for-kettle.html
4) http://stackoverflow.com/questions/15232294/converting-row-columns-to-rows-with-pentaho-kettle-pdi
(http://forums.pentaho.com/showthread.php?187160-Identify-duplicate-column-value-from-single-row)
USE CASE :
EXPECTED OUTPUT
Transformation Design :
References :
1) http://wiki.pentaho.com/display/EAI/Row+Normaliser
2) http://wiki.pentaho.com/display/EAI/Row+denormaliser
3) http://rpbouman.blogspot.in/2012/03/generic-normalizer-step-for-kettle.html
4) http://stackoverflow.com/questions/15232294/converting-row-columns-to-rows-with-pentaho-kettle-pdi
No comments:
Post a Comment