I want to extract the values of few fields from tExtractJSONFields and update a Database record
I want to extract the values of few fields from tExtractJSONFields and update a Database record. I can see the extracted values through tLogRow.
I can create an intermediate excel file with the extracted values and update a DB record, but don't want handle an intermediate file.Instead would like to get the values in context or global variable or something else and update a record in database.
Hi BN
If you want to store the value in a context variable or global variable temporarily and use it later, do it on tJavaRow, eg:
...tExtractJsonField--main--tJavaRow
-onsubjobok--other subjobs
on tjavaRow:
context.value=input_row.columnName;
or
globalMap.put("key",input_row.columnName);
I suggest to use tJavaRow to store the value to context variable for used later, but I don't see it in your job. It is a compilation error, open the Code tab, you will see which line / which component has the error.
