Skip to main content

I want to transform this JSON for import in a database what would be the best practice when using the standard transformers?

{
"keys":[
"day",
"domain",
"subject_identifier",
"kpi_type_code",
"kpi_count",
"kpi_value_min",
"kpi_value_max",
"kpi_value_avg",
"kpi_value_last",
"kpi_alert_condition_lower_limit_last",
"kpi_alert_condition_upper_limit_last",
"kpi_value_extremum_ok",
"kpi_value_avg_ok"
],
"values":[
[
"20240407",
"production",
"7ab20028",
"RA_MAP_FREQUENCY",
1256,
"24,0000",
"24,0000",
"24,0000",
"24,0000",
"0,9000",
"50,0000",
1,
1
],
[
"20240407",
"production",
"7ab20028",
"RA_EXCEPTIONAL_CONDITION_PERCENTAGE",
1440,
"5,9418",
"5,9418",
"5,9418",
"5,9418",
null,
"25,0000",
1,
1
],
]
}

Hi @fbrws 

 

Please, see attached file.

 

 


Hi @fbrws 

 

Please, see attached file.

 

 

Yes this works. Thanks a lot!!


Hi @fbrws 

 

Please, see attached file.

 

 

Yes this works. Thanks a lot!!

 

You aer wellcome


Reply