Tuesday, 3 January 2023

Penatho - Expressions

Compare two columns:

Source:


Comparison:


Pentaho Steps:




Use 'User Defined Java Expression' step in the pentho to achieve this, some sample expressions are below,

Count.equals(Tgt_Count) ? "TRUE" : "FALSE"

Value Type : String


Count<=Tgt_Count ? "OK" : "NOTOK"

Value Type : String

at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Data Sharing

  1. Create Share CREATE SHARE my_share; 2. Grant privileges to share GRANT USAGE ON DATABASE my_db TO SHARE my_share; GRANT USAGE ...