Am using Pentaho BI server with Data Integration to get data set and merge data from two input tables, Now i need to replace value of cell in each row, if two other columns in the same row matches my criteria, how can i accomplish this with Kettle?
I need to match many values with the cell value in each row, values to be matched with the cell are inside an excel sheet.
I have tried using Replace in string component but it does not work :( can you help me in this regard?