Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RMotta2408
Creator II
Creator II

Using tUnpivotRow with Excel files with different schemas

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:

RMotta2408_0-1717688204406.png

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:

RMotta2408_1-1717688484556.png

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

RMotta2408_2-1717688565539.png

And I get the desired result:

RMotta2408_3-1717688691758.png


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

 

Labels (1)
2 Replies
Shicong_Hong
Support
Support

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

RMotta2408
Creator II
Creator II
Author

Hello @Shicong_Hong ,

Could be any name.

Thank you,

Rui