Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
XavierDesp
Contributor
Contributor

Add Many column in table for each unique ID

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

 

 

Labels (1)
0 Replies