Forum Discussion

pranil2k2's avatar
pranil2k2
Contributor
5 years ago
Solved

JSON Splitter for an Split column

Hi, I have a requirement to read multiple XML files data and load into Oracle table. I am using Directory browser to read the list of XML files and passing the path to File reader and then XML Pars...
igormicev's avatar
igormicev
Contributor
5 years ago

Hi @Raph,

It’s very simple. You just need to not map the columns manually, i.e use from a Mapper this expression
$.mapValues((value,key) => value) into $ as target and that’s all.

Attached is a pipeline
Original order for columns_2020_10_24.slp (3.4 KB)

/Igor

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    4 years ago

    Hi @JensDeveloper,

    Please try with the following expression in a Mapper snap and let me know if it helps you
    $Name.mapValues(x=>$.entries()[1][1])

    BR Aleksandar.

    • JensDeveloper's avatar
      JensDeveloper
      Contributor II
      4 years ago

      YES it works, wow!
      Sorry but I was struggling a lot with language expressions and functions so I am Relieved. Thank you. I still need to learn a lot but I love it!