CODEWITHSUNDEEP
pentaho-spoonpentaho-data-integrationpdi
Theorp
Theorp

Reputation: 151

Upload multiple files to pentaho

In pentaho data integration, how do I import a list of xlsx files that are in the same folder?

note: the number of columns are always the same

Upvotes: 1

Views: 734

Answers (1)

Ahmmed
Ahmmed

Reputation: 1048

If your excel column name and sheet name are always same then you can use THIS solution. Here I have take all xlsx file from source folder and convert one-by-one file as csv. enter image description here

But if your excel columnname and sheet name are dynamic or you need some dynamic solution. Then you can use my another stackoverflow solution from Here

Upvotes: 1

Related Questions