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"