I am very new to Pentaho.
I have one table, it has type column which has different data, such as XML, text.
Here I am sending ex of type data: Type :
1."<HIntDetails>  <sKey>3</sKey>   <pID>132</pID>  <SName>Holt, R A</subjectName>  <facilityId>H</facilityId>  <facilityId>C</facilityId>  <summaryView>false</summaryView>  <timestamp>2013-12-30 (...)"     ---XML
2."<cliMessageKey>707</clinicalMessageKey>"
3."<details>  <methodName>getSourcesByFilter</methodName>  <parameters>                -----XML
<string>FacilityFilterModel{simpleStr='null', globalIdFuzzy='null', globalId='HEC', exactOnId=true, label='null', consumerOfLabs=null, creato (...)"         -------XML
4."PKey=77 SKey=30 pNameFormatted=Hoon, M F method=CONVERTER"              --text
Now I have to read this table and update the target table.
My target table has the below fields:
Skey 
Pkey 
Pgroup 
PID 
I have to read that table type column and I need to update the target, but I am not sure which tasks I need to accomplish this one.