Solved

Transform attribute after list indexer

  • 18 February 2022
  • 2 replies
  • 3 views

I get data via API in a JSON format. The values from "Points" need to be stored in seperate attributes. I managed to do so with JSON Fragmenter (json["points"][*]). With list indexer I can then store each index (0 & 1) to an attribute. But I can not transform then this attribute with DateTimeConverter.  

In the log I saw, that the list structure still exists in my dataset. I also found this information in the Feature Information (see screenshot).

 

How can I actually transform the list into a proper attribute?

 

JSON Structure:

{

  ...

  "name" : "xy",

  "modified" : "2022-02-16T10:16:53.066Z",

  "points" : [

   [ 1642633200000, 123.99 ],

 

String replacer Output vs. Feature Information:

image

icon

Best answer by takashi 18 February 2022, 10:10

View original

2 replies

Userlevel 2
Badge +17

Hi @hodelc​ , looks like the datetime value e.g. "1642633200000" is an elapsed time from the epoch in milliseconds. I think the DataTimeComverter could recognize it as a valid datetime value from epoch if you converted it to the value in seconds.

datetime = datetime / 1000 

Hi @Takashi Iijima​ 

Thanks, this solved my problem! I did the calculation with ExpressionEvaluator_Output

Reply