grouped many column in one

[Louveduval]

Hello , 

I'm sorry to bother you. I recieve a durty data with many column for un same class . 
For job  I ve  a PK  ,

"Aménagement intérieur", yes / no 
"Bois et dérivés", yes / no 
Chauffage, yes / no 
Couverture, yes / no 
Cuisine, yes / no  
and 13 other yes / no 

So I want  to avoid a IF  "Aménagement intérieur"= yes , job = "Aménagement intérieur", if "Bois et dérivés"=yes , job = "Bois et dérivés", ..... 
But I don't now how to use a wild map or a mapping to  have a table with the PK and job 

Can you help me ? 

[MarcoWedel]

Please post some sample data and your expected result.

[Louveduval]

And just have 

job:

Load
"Réf. maitre",

job

ROM [lib://ORCAB lecteur S (orcab_fabien.airiau)/INFORMATIQUE/PUBLIC/SALON/QLIK_Exposants_Global-202304131427.xls]
(html, codepage is 28591, embedded labels, table is @1);

And have  

"Réf. maitre",job

1 Bois et dérivés

2 Bois et dérivés

3  Couverture

[Louveduval]

help :3

[Louveduval · Accepted solution]

Finally I've made a cross table as temp and after a new table with a where >0  close