Changing a field from String to Int in Pentaho Data Integration

pentaho kettle data-integration
Dan picture Dan · Jan 21, 2014 · Viewed 21.8k times · Source

I am taking JSON information from our online API and producing it in a table with DI. I have 4 fields url, deviceId, displacement & timestamp. These are all recorded as Strings but I want them to be Int values, bar the url.

In the Generate Rows section I tried changing each parameter to an Int but the results would not show up but if I left them as Strings, it will post the results.

Any help on how I could change the data from type String to Int and still have my data reported?

Answer

Helping Hand.. picture Helping Hand.. · Jan 22, 2014

Take Select/Rename values Step, and change the data-type in meta-data section.

Related questions

Use JSON Input step to process uneven data

I'm trying to process the following with an JSON Input step: {"address":[ {"AddressId":"1_1","Street":"A Street"}, {"AddressId":"1_101","Street":"Another Street"}, {"AddressId":"1_102","Street":"One more street", "Locality":"Buenos Aires"}, {"AddressId":"1_102","Locality":"New York"} ]} However this seems not to be possible: Json …

Read More
pentaho kettle : get row count from stream

I would like to get the total record count from the get rows from result output and then pass it to parent job. Any suggestions ?

Read More
Send Email with pentaho PDI

I want to sent an email using PDI. I created an job and added the 'Mail' element. There are my parameters. Server smtp.gmail.com Port: 587 Use Authentication User : mygmailusername Pass : mygmailpass Secure Con Type : TLS When I run the …

Read More