Hi all,

Once again I need the communities' help regarding Kettle v4.1.

I have in one of my tables a column which contents I want to transform into other columns.

I shall give an example of this:

  • In table A I have a column, let's say, attributedescriptions with the following content:

    Attribute_1=Title{CR}
    Attribute_2=Company{CR}
    Attribute_3=Department{CR}


Now, the number of attributes is variable, and these are separated with {CR}, and I want to transform these attributes to another table, into columns.

That being said, the outcome of the transformation should be:

  • TABLE B:

    Column 1 - Column_Name = Title. Cell value: Dr.
    Column 2 - Column_Name = Company. Cell value: Pentaho
    Column 3 - Column_Name = Department. Cell value: Health


How can I do this?

Best regards,

--jr, Portugla