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)

Kiro - Core Features

What is Kiro Kiro is an innovative AI-powered IDE that revolutionizes software development through intelligent assistance and structured wor...

  • CACHING in Snowflake
    Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
  • List
    #Sample   thislist = [ "apple" , "banana" , "cherry" ] print ( "MyList : " , thislist ) ​ thislist...
  • Create Index
     CREATE INDEX sync_idx_abc ON schemaname.tablename(columnname);