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