How to get the expected output using JoltTransforms in nifi?

Question

Unable to transform the below Input json into expected format using JOLT.

Note: FExchangeCurrency_ExchangeRate values need to get in 2nd row in Expected output.

Input:

[
  {
    "ExchangeCurrency": "INR",
    "FExchangeCurrency": "AUD",
    "ExchangeRate": 123,
    "ExchangeDate2": "2023-05-01"
  },
  {
    "ExchangeCurrency": "INR",
    "FExchangeCurrency": "CHF",
    "ExchangeRate": 234,
    "ExchangeDate2": "2023-05-01"
  },
  {
    "ExchangeCurrency": "INR",
    "FExchangeCurrency": "EUR",
    "ExchangeRate": 456,
    "ExchangeDate2": "2023-05-01"
  }
]

Expected Output:

{
  "ExchangeCurrency" : "INR",
  "ExchangeDate2" : "2023-05-01",
  "AUD_ExchangeRate" : 123,
  "CHF_ExchangeRate" : 234,
  "EUR_ExchangeRate" : 456
}

What did you try to achieve? I meant where is your attempted JOLT code? This forum helps only if you get stuck somewhere. — Arun Sai Mustyala, May 23 '23 at 12:32

score 1 · Answer 1 · answered May 23 '23 at 12:45

You can use the following spec

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "ExchangeRat*": "@(1,FExchangeCurrency)_&",
        "ExchangeD*|ExchangeC*": "X.&" // others, which has no rendering applied, qualified with an arbitrary letter X
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": "&1&"
      },
      "X": {
        "*": {
          "0": "&1" // only pick single one of repeated identical components
        }
      }
    }
  }
]

How to get the expected output using JoltTransforms in nifi?

1 Answers1