But I want to do this without making any changes to the database. The transformation ran successfully when I changed to the table datatype to "character varying" in my local DB. Hint: You will need rewrite or cast the expression. ERROR: column "content" is of type xml but expression is of type character varying. I created a transformation to do the above but I get an error. Aggregate Designer operates on Pentaho Analysis (Mondrian) XML schema files and the database with the underlying tables described by the schema to generate. I'd like to thank those who have encouraged me to write this book: On one hand, the Pentaho community they have given me a rewarding feedback after the Beginner's book. You can follow her on Twitter at mariacroldan. The data in the CSV file is Number,Email,Email Communication,Member format table column is of XML datatype She is the author of Pentaho 3.2 Data Integration: Beginner's Guide published by Packt Publishing in April 2010. Confidential /SQL, JavaScript, HTML, Text, Rich-Text-File, XML and CSV. load them into a data warehouse enhancing the coherence and quality of data. Have a requirement to extract data from CSV file and then transform it into XML to finally load into target. Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon.