Using tUnpivotRow with Excel files with different schemas

RMotta2408 — Thu, 06 Jun 2024 15:56:04 GMT

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

Re: Using tUnpivotRow with Excel files with different schemas

Shicong_Hong — Fri, 14 Jun 2024 09:44:45 GMT

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

Re: Using tUnpivotRow with Excel files with different schemas

RMotta2408 — Fri, 14 Jun 2024 09:48:37 GMT

Hello @Shicong_Hong ,

Could be any name.

Thank you,

Rui

topic Using tUnpivotRow with Excel files with different schemas in Talend Studio

Using tUnpivotRow with Excel files with different schemas

Re: Using tUnpivotRow with Excel files with different schemas

Re: Using tUnpivotRow with Excel files with different schemas