Skip to main content
Solved

Complicated JSON key-values as import for a database table


fbrws
BANNED
Forum|alt.badge.img+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
],
]
}

Best answer by danilo_fme

Hi @fbrws 

 

Please, see attached file.

 

 

View original
Did this help you find an answer to your question?

3 replies

danilo_fme
Evangelist
Forum|alt.badge.img+42
  • Evangelist
  • Best Answer
  • April 8, 2024

Hi @fbrws 

 

Please, see attached file.

 

 


fbrws
BANNED
Forum|alt.badge.img+2
  • Author
  • BANNED
  • April 8, 2024
danilo_fme wrote:

Hi @fbrws 

 

Please, see attached file.

 

 

Yes this works. Thanks a lot!!


danilo_fme
Evangelist
Forum|alt.badge.img+42
  • Evangelist
  • April 8, 2024
fbrws wrote:
danilo_fme wrote:

Hi @fbrws 

 

Please, see attached file.

 

 

Yes this works. Thanks a lot!!

 

You aer wellcome


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings