Welcome Guest! Log in


The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Inversion de pivot / reversing pivot

  • npernoud@grandlyon.com
  • npernoud@grandlyon.com's Avatar Topic Author
  • Offline
24 Oct 2016 14:26 #1 by npernoud@grandlyon.com
Inversion de pivot / reversing pivot was created by npernoud@grandlyon.com

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

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

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.