Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: JSON get key and value in separate columns

  1. #1
    Join Date
    Oct 2017

    Default JSON get key and value in separate columns

    Hi all,
    I am working with Kettle and JSON. If I have a file like this:
    how can I get an output with 2 columns where
    Name Value
    USDAED 3.672497
    USDAFN 68.150002
    USDALL 114.949997
    ... ...

    I used the forum and google to search an answer to this without luck.

    Thanks in advance to everybody helps me

  2. #2
    Join Date
    Jun 2016


    Hi m.riezzo,

    Please find the attached transformation , this will help you.

    Json Poc.ktr

    Thank you,
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.