Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Employee
Employee

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