Solved

Complicated JSON key-values as import for a database table

  • 8 April 2024
  • 3 replies
  • 35 views

Badge +2

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
],
]
}

icon

Best answer by danilo_fme 8 April 2024, 18:39

View original

3 replies

Userlevel 5
Badge +30

Hi @fbrws 

 

Please, see attached file.

 

 

Badge +2

Hi @fbrws 

 

Please, see attached file.

 

 

Yes this works. Thanks a lot!!

Userlevel 5
Badge +30

Hi @fbrws 

 

Please, see attached file.

 

 

Yes this works. Thanks a lot!!

 

You aer wellcome

Reply