I need a JOLT spec to do the below transformation in an Apache NiFi JOLT processor. So there are arrays that are all the same length (in this case 3), and so I want to expand it into 3 records…
I have data coming into NiFi in JSON format. Below is the sample { "company_name": "mycompany", "companytyp": "producer", "Welcomemes": "welcome_message1", "logo": "//somepath/to/logo URL " } I have been trying to apply a JOLT transformation for the following condition: If the…
I am facing a problem, transforming a very complex nested JSON using jolt transformation. Input and output detail is given below. Input [ { "metadata": { "event_time": "2023-09-04T08:46:15.0842Z" }, "payload": [ { "plant": "0DE1", "store": "", "t_objectandcharvalcomb": [ { "productalloccharacteristic01":…
I am facing a problem, transforming a JSON . Requirement is to concatenate only if my two columns are not Null, default value if any of one column is NULL Input 1 : [ { "division_Code": "F", "department_Code": "L3D4", "department":…
I am running Nifi (A GUI based application) inside Docker container. it was deployed using docker compose compose: nifi: hostname: DWH_Nifi_prod container_name: nifi_container_persistent image: 'apache/nifi:1.19.0' # latest image as of 2023-June. restart: on-failure user: root ports: - '8091:8080' It is…
As part of data preprocessing I need to remove all empty values from an input JSON like empty arrays [], empty objects {}, empty strings ""/" "/"t", objects with empty keys {"":5} and I need to do that recursively. I…
I am trying to replace API Data with "All" in Emp_Id field in data in json. And then make rows with every data of API. I tried in ecmascript but I need in Java as this map function is giving…
I want this data to be transformed in a given way using the jolt spec of Nifi. Conditions are if studentId and loc_id are the same then we will combine their info and will pass the rest as it is.…
How can I transform(remove in this case) flowfile if one of the fields of the object is null using JoltTransformJson processor in nifi here below is my data. emp.json: [ { "Name" : "john Smith", "DOB" : "2000-07-14", "Salary" :…
I'm rather new to JOLT transformations so I'm still having trouble with pretty basic stuff. I have a big JSON payload that I need to simplify by removing most data from it. The only attributes I want to keep are…