Json Input: { "value_schema_id": "GBM_KF_DH_ClientFilter", "system_code": "LogMessage", "event_type": "PROCESSOR", "metric_name": "ERROR", "metric_id": "1", "global_person_profile_id": "2", "create_ts": "3" } JOLT Specification: [ { "operation": "shift", "spec": { "value_schema_id": "value_schema_id", "system_code": "records[1].value.system_code", "event_type": "records[1].value.event_type", "metric_name": "records[1].value.event_detail.metric_name", "metric_id": "records[1].value.event_detail.metric_id", "global_person_profile_id": "records[1].value.event_detail.global_person_profile_id", "create_ts": "records[1].value.event_detail.create_ts" } } ] Json Output { "value_schema_id" : "GBM_KF_DH_ClientFilter", "records" : [ null, { "value" : { "system_code" : "LogMessage", "event_type" : "PROCESSOR", "event_detail" : { "metric_name" : "ERROR", "metric_id" : "1", "global_person_profile_id" : "2", "create_ts" : "3" } } } ] }   Can you please help me to take out nulls from the output-json.  ... View more

Hi, Can someone please help me in transforming below json, I tried by following the nifi jolt transormation guide available in the community, but I couldn't. Thanks in advance. [ { "value_schema_id" : "XXXXXXX", "system_code" : "XXXXXXXXX", "event_type" : "XXXXXXXXX", "metric_name" : "XXXXXXX", "metric_id" : "1", "global_person_profile_id" : "2", "create_ts" : "3" }, { "value_schema_id" : "XXXXXXX", "system_code" : "XXXXXXX", "event_type" : "XXXXXXXXX", "metric_name" : "XXXXXXX", "metric_id" : "1", "global_person_profile_id" : "2", "create_ts" : "3" } ] As mentioned below: {   "value_schema_id": XXXXXX,   "records": [     {       "value": {         "system_code": "XXXXXX",         "event_type": "XXXXXX",         "event_detail": {           "metric_name": "XXXXXX",           "metric_id": "XXXXXX",           "global_person_profile_id": "XXXXXX",           "create_ts": "XXXXXX"         }       }     }   ] } ... View more

Hi,   I have a table with 526 columns. QueryDataBase processor is not able to fetch all the rows and it is failing. I am stuck on how to proceed further or which processor to use to fetch the rows. Can someone please guide me.  ... View more