Tag: how to create case etl code in pentaho

CASE Statement in Pentaho

admin

Today, I will discuss about how to create ETL(Pentaho) Equivalent of case statement in Database. In Pentaho, we have component “Number Range”. See the ETL Design for the same. In this, I have considered csv file input ,Number Range,Write to log components. In CSV file input, FEB-SAL.csv file which we have considered. See the below SS for the same. See the below SS for the Number Range Component. Number Range works on x1 less than equal to(<=) x greater than(<) x2 logic. Here, if you see, 1000 to 5000 ,…