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 !