AnsweredAssumed Answered

Pentaho JSON Input

Question asked by Michael Zandstra on Feb 15, 2018
Latest reply on Feb 21, 2018 by Gotn O'Guts

Hi,

I was wondering if somebody could help me with probably something relatively easy. I would like to use https://api.fixer.io/latest to add some currencies into my Date Warehouse. I would like to add them row by row so in a table like ( currency CHAR(4), value REAL). Is this possible with the JSON Input? Or should I go for a table like (AUD REAL, USD REAL, JPY REAL) and than break it down later with a transformation?

Thanks in advance.

Outcomes