I have the following JSON { "Data": { "totalExecutionTime": "00:00:00.5544916", "totalCount": "33414", "Items": [ { "featureId": 100, "featureName": "Product", "id": 5903, "parentId": 0, "brand": "Normal", "order": 0, "createdDate": "2022-08-18T19:00:57.44", "modifiedDate": "2024-07-10T13:21:29.123", "Values": [ { "featureId": 100, "featureName": "Value", "seq": 0,…
I have the following JSON type file: [{ "sid": "s-mtl-1", "MaterialNumber": "0.4440", "MaterialWNumber": "W0.4440", "tubePrice": "12"}, { "sid": "s-mtl-2", "MaterialNumber": "0.5550", "MaterialWNumber": "W0.5550", "tubePrice": "13"}, { "sid": "s-mtl-3", "MaterialNumber": "0.6660", "MaterialWNumber": "W0.6660", "tubePrice": "14"}] And I would like to remove…
For example, there are two tables like this: 1.original table date_str 2016-02 2016-02-02 2.new table(Created based on the original table, an additional is date field is added) date_str is_date 2016-02 2016-02-02 date_str in the original table should be in date…
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 am trying to clean the json file down below. I want to remove all the dict key value pairs for which the key is "Company" in the "Stores" list. { "Company": "Apple", "Stores": [ {"Company" : "Apple", "Location" :…
I have over 1,000 JSON files representing game elements. This is a typical example: { "name": "Reeve Hunter", "edition": 3, "revision": "2021 v1", "keywords": [ "Circle", "Wolf Sworn", "Reeve of Orboros", "Solo" ], "point cost": 4, "field allowance": 2, "models":…
I am currently studying SQL and I am still a newbie. I have this task where I need to split some rows with various entries like dates and user IDs. I really need help +-------+------------------------------+---------------------------+ | TYPE | DATES |…