Hello,
I create a table with only distrib action.
distributions_0:
load distinct
"ID Sondage" as "ID Distrib",
"Horodate Sondage" as "DIST Date",
"DIST Bac" as "DIST ModeleBac",
"DIST CodeCuve" as "DIST Cuve",
"DIST CodePuce" as "DIST Puce",
"ID Usager Sondage" as "ID Usager Distrib",
"Lib Nom Sondage" as "DIST Nom Usager",
"Lib Equipe Sondage" as "DIST Equipe"
Resident sondages
where "Lib Action Sondage" = 'DIST'
In this table, i have for one "ID Usager" many DIST row.
I want create one row by "ID Usager" and many column by "DIST"
Exemple :
ID |
DIST Bac 1 |
CodeCuve 1 |
CudePuce1 |
DISTBac 2 |
Codecuve2 |
Codepuce2 |
DISTBac 3 |
Codecuve3 |
Codepuce3 |
4022 |
320L |
9494 |
9090 |
140L |
8787 |
9888 |
230L |
3626 |
3722 |
I think use "for each" ?
Thanks for you return.
Xavier