Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
MDE_PF
Contributor II
Contributor II

création colonnes avec séparateur multiples

Bonjour à tous,

 

Je souhaite créer plusieurs colonnes à partir d'une colonne contenant des métadonnées.

Le problème que je rencontre est la multitude de "séparateur" présents.

Exemple ci dessous :

 

Métadonnées alarmes
{"alarms":{"alarms":[{"alarmCode":"P021","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P035","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P150","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P505","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P506","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P510","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P601","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P626","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P629","description":"Undefined Alarm","severity":"red"},{"alarmCode":"P637","description":"Undefined Alarm","severity":"red"}],"changedAtTime":"2022-01-17T04:18:16.887Z"}}

 

Idéalement, j'aimerai ressortir avec ceci :

Alarms Code DESCRIPTION Severity Changed at Time (date) Changed at Time (time)
P021 Undefined Red 18/01/2022 16:43
P626 Undefined red 19/01/2022 17:43

 

Auriez-vous une idée du script correspondant ?

 

Un grand merci !

Labels (4)
0 Replies