Pentaho

You'll have to work with Metadata Injection, first to read the excel file and pass to the excel input step all the date columns to read and then to the row normaliser step the names of the columns to normalise as date (and the values, that would be the same as the column name)

Thank you Ana!

I'm a little bit confused about when and how to use metadata injection in my transformation flow.

I suppose before to read excel file, since the "date" columns are variables. It's so?

Do you have any examples that I can follow?

You have a samples folder in your installation. Inside the transformations folder, you have the meta-inject folder with an example of how metadata injection works, precisely to read a csv file. Read the documentation about metadata injection also.

When creating a new transformation with metadata injection, I like to check the box to generate a transformation with the metadata injected to debug what I'm doing.

well.

Thanks Ana for your suggestions.

Bye!