Using tUnpivotRow with Excel files with different schemas

[RMotta2408]

Hi everyone,

I've created a Job that reads an Excel file and pivots some columns to rows. So far so good.
This is the Excel file:

Even though I'm using a dynamic schema (*) to read the file, I still have to know the real schema of the file so that I can configure the tExtractDynamicFields component correctly:

Then I use the tUnpivotRow component like this (because these columns are always constant):

And I get the desired result:

Thus far all is good.
The problem starts when I start getting Excel files with different schemas (mind you, the first 3 columns are always the same: Name, Surname, City).
(*) This is why I'm using the dynamic schema to read the Excel file.
How do I work with these files? How do I make my Job ready for any Excel that comes with a different schema than the one I'm using in this Job? 

Thank you,
Rui

[Shicong_Hong]

The column name always be like this: code1, code2, code3, ... or could be any name?

[RMotta2408]

Hello @Shicong_Hong ,

Could be any name.

Thank you,

Rui