CODEWITHSUNDEEP
csvmappingpentahokettlepentaho-spoon
MEhsan
MEhsan

Reputation: 2324

How to Get Data from CSV File and Send them to Excel Using Pentaho?

I have a tabular csv file that has seven columns and containing the following data:

ID,Gender,PatientPrefix,PatientFirstName,PatientLastName,PatientSuffix,PatientPrefName
2 ,M     ,Mr           ,Lawrence        ,Harry          ,             ,Larry

I am new to pentaho and I want to design a transformation that moves the data (values of the 7 columns) to an empty excel sheet. The excel sheet has different column names, but should carry the same data, as shown:

prefix_name,first_name,middle_name,last_name,maiden_name,suffix_name,Gender,ID

I tried to design a transformation using the following series of steps, but it gives me errors at the end that I could not interpret them.

step

What is the proper design to move the data from the csv file to the excel sheet in this case? Any ideas to solve this problem?

Upvotes: 0

Views: 968

Answers (1)

Marlon Abeykoon
Marlon Abeykoon

Reputation: 12495

As @Brian.D.Myers mentioned in the comment you can use select values step. But here is how you do it step by step explanation.

csv_to_excel_full_ktr

  1. Select all the fields from CSV file input step.
  2. Configure the select values step as follows.

select_values_configuration

  1. In the Content tab of Excel writer step click on Get fields button and fill the fields. Alternatively you can use Excel output step as well.

Upvotes: 2

Related Questions