1

I am new to Pentaho. I am trying to build a transformation that can convert a bunch of .xlsx files to .csv (utf-8). I tried Get file Names and Text File Output, but it saves a single file as csv and the content of that file is the file properties. I also tried Microsoft Excel Input and Microsoft Excel Output and that did not work either.

Any help will be appreciated. TIA!

glen_11
  • 21
  • 2

2 Answers2

1

I have prepare a SOLUTION for you. I have made my solution full dynamic. For that reason solution is combination of 6 (transformation & job). You only need to define following 2 things:-

  1. Source folder location
  2. Destination folder location

Others will work dynamically.

enter image description here

Also, I have learn a lot with this solution.

enter image description here

Ahmmed
  • 1,038
  • 1
  • 5
  • 13
  • Hi @Sakil Ahmmed, thanks for sharing the solution! I tried this but it created csv files in the destination folder with completely different data in them. Am I supposed to mention the column headers somewhere? – glen_11 Mar 26 '21 at 17:37
  • Not you don't require to mentioned any column headers.Can you please share your sample one .xlsx file or your solution what you tried with me? I was also attached some sample .xlsx file with my solution , so you can run my soultion and can see the csv output (for understanding) – Ahmmed Mar 26 '21 at 18:15
0

Would you like to generate a separate CSV for each Excel file? It is better to do it like this:

  1. Using the Get File Names component, read the list of Excel files from the folder.
  2. Then call Execute Transformation, and pass the name of the file.

Then a separate Transformation will be performed for each file, and a separate CSV will be generated in it for each Excel file.

OLAPseek
  • 26
  • 1