Pentaho

 View Only

 Sort component doesnt sort properly on the data

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
archana garikapati's profile image
archana garikapati posted 06-11-2019 21:49

i am using the sort component to sort my data - 1, 3,4,7,2,6,5,8,10,9.

It does in the below order. please suggest

 1

10

2

3

4

5

6

7

8

9


#Pentaho
#PentahoDataIntegrationPDI
#Kettle
Naveen Kumar's profile image
Naveen Kumar

Result appears to be String sort. Is the type defined as String, or left undefined which by default considers String.

Change the data type to Integer to sort by the numeric order.

Regards,

Naveen

archana garikapati's profile image
archana garikapati

thanks