Hello,
As indicated by email earlier, you can setup a mapping, which will:
- load the excel file to a temp table
- transform this temp table reversing the pivot
I attach a sample process to this topic so that other users can consult it. It works with the Demo Database.
The load Excel => Table part is not included in this sample, the idea is to show how to use a stage for unpivot transformation.
This attachment is hidden for guests.
Please log in or register to see it.