Question Inversion de pivot / reversing pivot

Bonjour,

J'ai une table, issue d'un fichier xls, du type / I have a table, from an xls file as below :

Date;Donnée A;Donnée B;Donnée C
01/01/2016;10;20;30
02/01/2016;40;50;60
...
31/01/2016;70;80;90

Et je souhaite obtenir une table du type / I'd like to get a table as below :
01/01/2016;Valeur A;10
01/01/2016;Valeur B;20
01/01/2016;Valeur C;30
02/01/2016;Valeur A;40
02/01/2016;Valeur B;50
02/01/2016;Valeur C;60
...
31/01/2016;Valeur A;70
31/01/2016;Valeur B;80
31/01/2016;Valeur C;90

Est ce possible avec Stambia ? Si oui comment ? / Is it possible to do so with Stambia ? If it is : how so ?

Merci, / Thanks

Bien cordialement / Best regards.

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.