Welcome Guest! Log in

Topic-icon Question Inversion de pivot / reversing pivot

  • npernoud@grandlyon.com
  • npernoud@grandlyon.com's Avatar Topic Author
  • Offline
More
24 Oct 2016 14:26 #1 by npernoud@grandlyon.com
npernoud@grandlyon.com created the topic: 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.

Please Log in or Create an account to join the conversation.

More
25 Oct 2016 14:26 - 25 Oct 2016 14:27 #2 by Thomas BLETON
Thomas BLETON replied the topic: Inversion de pivot / reversing pivot
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.

This message has an attachment file.
Please log in or register to see it.

Last Edit: 25 Oct 2016 14:27 by Thomas BLETON.

Please Log in or Create an account to join the conversation.