How to concatenate a string in a Pentaho box?

I am new to Pentaho (installed today). I was able to do a basic transformation in Spoon. Now I need to do something, and I can’t figure out how to do it.

my input looks like

2012-09-17|garima|fbhjgjhgj87687jghgj88jgjj|garima#1347868164626|::ffff:120.56.132.137

The third field is the identifier for which I need to get some information from the REST API

http://api.app.com/app/api/v1/feature/fbhjgjhgj87687jghgj88jgjj

What do I need to do in Spoon to do this?

In addition, the data will be returned in json format. How do I make it out?

+5
source share
2 answers

You must first enter your input CSV File Inputusing |as a delimiter. Then you can get the third field as a string.

, , String operations. Remove special character space.

http- http://api.app.com/app/api/v1/feature/. Calculator. tmpAddr, Define a constant value for ... ( - , , ). Field A http-. , , , , , ( Edit -> System Variables).

Calculator , MyAddress, A+B. Field A tmpAddr, , Field B 3- .

MyAddress. REST client. Accept URL from field MyAddress URL Field Name. Application Type JSON. Result Fieldname MyResult.

JSON, Json input. Source is defined in a field MyResult Get Source from field.

+7

, " ", .

  • ' RegEx' Y
  • "" (.*)
  • " " http://api.app.com/app/api/v1/feature/$1
  • " " Y

, $X

+1

All Articles