I have a json as below. While performing metadata scanning, I am able to get name, id but data is a hashmap/dictionary with datetime as key and its corresponding value.
Can I please know how to parse the dictionary/hashmap in the below json using talend components ?
2) Start a new SubJob with a tJavaFlex. In the Start Code section, get the keyset of your HashMap and start an iteration over that keyset. For example...
3) In your Main Code section, retrieve your records and output to the columns you should have manually configured. There will be a row for each loop of this section. This section is controlled by the while loop opened in the Start Code.
row1.myColumn = yourHashMap.get(keysIt.next());
4) Then in the End Code section, simply close the while loop and do any other tidy up you may wish to do...
I don't believe there is a way of doing this with Talend components.I *think* there was a Jira set up for this. However you can do this with a bit of Java and a tJavaFlex/tJavaRow. Take a look at the solution for this question. You will need to know Java to do this and if you have Java you should be able to extrapolate from this....
I was able to process the json and get key value pairs using below code. Also please see attached screenshot of current job. I now want to pass the key value pairs processed in java_row component and pass them to next component like say (tSortRow) where I can sort the output based on date in ascending order and store datetime, value in CSV file.
Can I please know on how to pass the key value pairs as individual columns to next components ?
System.out.println(row1.Body.substring(1, row1.Body.length() - 1));
JSONObject jsonObject = new JSONObject(row1.Body.substring(1, row1.Body.length()));
JSONObject value = jsonObject.getJSONObject("data");
Iterator<?> keys = value.keys();
StringBuilder builder = new StringBuilder();
Date date = null;
DateFormat format = new SimpleDateFormat("yyyy-MM-dd'T'hh:mm:ss");
SimpleDateFormat sdfDestination = new SimpleDateFormat("dd-MMM-yyyy hh:mm:ss");
while(keys.hasNext() ) {
String key = (String)keys.next();
date = format.parse(key);
String destDate = sdfDestination.format(date);
double value_1 = value.getDouble(key);
System.out.println(destDate + "," + value_1);
}
2) Start a new SubJob with a tJavaFlex. In the Start Code section, get the keyset of your HashMap and start an iteration over that keyset. For example...
3) In your Main Code section, retrieve your records and output to the columns you should have manually configured. There will be a row for each loop of this section. This section is controlled by the while loop opened in the Start Code.
row1.myColumn = yourHashMap.get(keysIt.next());
4) Then in the End Code section, simply close the while loop and do any other tidy up you may wish to do...
