Search code examples
pentahokettledata-integration

Changing a field from String to Int in Pentaho Data Integration

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?

Solution

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