title: Merging 2 rows in pentaho kettle transformation
body: <p>My KTR is:
  <img src="https://i.stack.imgur.com/aKJ1R.jpg" alt="enter image description here"></p>
  
  <p>MongoDB Json Input gives the JSON as follows:</p>
  
  <blockquote>
    <p>{ "_id" : { "$oid" : "525cf3a70fafa305d949ede0"} , "asset" :
    "RO2500AS1" , "Salt Rejection" : "82%" , "Salt Passage" : "18%" ,
    "Recovery" : "56.33%" , "Concentration Factor" : "2.3" , "status" :
    "critical" , "Flow Alarm" : "High Flow"}</p>
  </blockquote>
  
  <p>And one Table input which returns 2 rows:</p>
  
  <p><img src="https://i.stack.imgur.com/A0i48.jpg" alt="enter image description here"></p>
  
  <p>In StreamLookUp step, Key to look up is configured as asset = AssetName</p>
  
  <p>My final Output is returning 2 jsons:</p>
  
  <blockquote>
    <p>{"data":[{"Estimated Cost":"USD
    15","AssetName":"RO2500AS1","Description":"Pump
    Maintenance","Index":1,"json":"{ \"_id\" : { \"$oid\" :
    \"525cf3a70fafa305d949ede0\"} , \"asset\" : \"RO2500AS1\" , \"Salt
    Rejection\" : \"82%\" , \"Salt Passage\" : \"18%\" , \"Recovery\" :
    \"56.33%\" , \"Concentration Factor\" : \"2.3\" , \"status\" :
    \"critical\" , \"Flow Alarm\" : \"High
    Flow\"}","Type":"Service","DeadLine":"13  November 2013"}]}</p>
    
    <p>{"data":[{"Estimated Cost":"USD
    35","AssetName":"RO2500AS1","Description":"Heat
    Sensor","Index":2,"json":"{ \"_id\" : { \"$oid\" :
    \"525cf3a70fafa305d949ede0\"} , \"asset\" : \"RO2500AS1\" , \"Salt
    Rejection\" : \"82%\" , \"Salt Passage\" : \"18%\" , \"Recovery\" :
    \"56.33%\" , \"Concentration Factor\" : \"2.3\" , \"status\" :
    \"critical\" , \"Flow Alarm\" : \"High
    Flow\"}","Type":"Replacement","DeadLine":"26  November 2013"}]}</p>
  </blockquote>
  
  <p>I want my final JSON output to merge show result something like:</p>
  
  <blockquote>
    <p>{"data": [{"Estimated Cost":"USD 15", "AssetName":"RO2500AS1",
    "Description":"Pump Maintenance", "Index":1, "Type":"Service",
    "DeadLine":"13  November 2013"}, {"Estimated Cost":"USD 35",
    "AssetName":"RO2500AS1", "Description":"Heat Sensor", "Index":2,
    "Type":"Replacement", "DeadLine":"26  November 2013"}],</p>
    
    <p>"json":{ "_id" : "525cf3a70fafa305d949ede0"} ,  "asset" : "RO2500AS1"
    ,  "Salt Rejection" : "82%" ,  "Salt Passage" : "18%" ,  "Recovery" :
    "56.33%" ,  "Concentration Factor" : "2.3" ,  "status" : "critical" , 
    "Flow Alarm" : "High Flow"}</p>
  </blockquote>
  
  <p>which means merging 2 rows. </p>
  
  <p>Can anybody help please</p>