Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: JSON get key and value in separate columns

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Oct 2017
    Posts
    1

    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:
    Code:
    {
        "success":true,
        "terms":
        "https:\/\/currencylayer.com\/terms",
        "privacy":"https:\/\/currencylayer.com\/privacy",
        "timestamp":1509365052,
        "source":"USD",
        "quotes":{
            "USDAED":3.672497,
            "USDAFN":68.150002,
            "USDALL":114.949997,
            "USDAMD":481.73999,
            "USDANG":1.780291,
            ...
        }
    }
    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
    Posts
    107

    Default

    Hi m.riezzo,


    Please find the attached transformation , this will help you.


    Json Poc.ktr


    Thank you,
    Ram
    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.