How to get column names and corresponding column values

Hi @spinaka,

I do not understand the “Column mapping data from parameter”. You are sending this array as parameter in the pipeline or something ?

Here is a solution that might help you, if it’s not correct just answer me question above.

My sample data for the expression:

[
  {
  "ID":1,
  "NAME":"testuser",
  "Mapping": [
      {
      "src_col_name": "ID",
      "tgt_col_name": "sys_id"
      },
      {
      "src_col_name": "NAME",
      "tgt_col_name": "user_name"
      }
    ]
  }
]

Expression:
$.mapKeys((value, key) => $Mapping.findIndex(el => el.src_col_name == key) >= 0 ? $Mapping.find(element => element.src_col_name == key).tgt_col_name : key)

Output:

[
  {
    "sys_id": 1,
    "user_name": "testuser"
  }
]

Regards.
Viktor