Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !