like operations in Pentaho

Let us discuss about How to implement Like operations in Pentaho.Here, I have designed the transformation to handle like operation which is same as like clause in database. See the below Transformation design. See the values in the Generate rows components. See the code written in Modified JavaScript Value Component.Here if you see I have used function “getOcuranceString” which will give value in terms of number of occurrences of a substring in the main string. In other words, we can say if it returns value 0 that means value which…