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.