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...
  • Aleksandar_A's avatar
    Aleksandar_A
    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.

pranil2k2's avatar
pranil2k2
Contributor
5 years ago
Copy LinkReport

Thanks for the help. i didnt do any changes but now the JSON splitter is working as excepted. i just delete every thing and re created.
Thanks again

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    4 years ago
    Copy Link

    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
      Copy Link

      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!