LogoLogo
⌘Ctrlk
Try Pentaho! - Start your 30 day evaluation today
  • Pentaho Documentation
GitBook Assistant
GitBook Assistant
GitBook Assistant
Good afternoon

I'm here to help you with the docs.

⌘Ctrli
AI Based on your context
LogoLogo
  • Pentaho Data Integration
  • Get started with the PDI client
  • Use a Pentaho Repository in PDI
  • Data Integration perspective in the PDI client
  • Schedule perspective in the PDI client
  • Streaming analytics
  • Advanced topics
  • Troubleshooting possible data integration issues
  • PDI transformation steps
    • Abort
    • Add a Checksum
    • Add sequence
    • AMQP Consumer
    • AMQP Producer
    • Avro Input
    • Avro Output
    • Calculator
    • Cassandra Input
    • Cassandra Output
    • Catalog Input
    • Catalog Output
    • Common Formats
    • Copybook Input
    • CouchDB Input
    • CSV File Input
    • Data types
    • Delete
    • ElasticSearch Bulk Insert (deprecated)
    • Elasticsearch REST Bulk Insert
    • ETL metadata injection
    • Execute Row SQL Script
    • Execute SQL Script
    • File exists (Step)
    • Get records from stream
    • Get rows from result
    • Get System Info
    • Group By
    • Hadoop File Input
    • Hadoop File Output
    • HBase Input
    • HBase Output
    • HBase row decoder
    • HBase setup for Spark
    • Java filter
    • JMS Consumer
    • JMS Producer
    • Job Executor
    • JSON Input
    • Kafka consumer
    • Kafka Producer
    • Kinesis Consumer
    • Kinesis Producer
    • Mapping
    • MapReduce Input
    • MapReduce Output
    • Memory Group By
    • Merge rows (diff)
    • Microsoft Excel Input
    • Microsoft Excel Output
    • Microsoft Excel Writer
    • Modified Java Script Value
      • General
      • Java script functions pane
      • Java Script pane
      • JavaScript Internal API Objects
      • Examples
        • Check for the existence of fields in a row
        • Add a new field in a row
        • Use NVL in JavaScript
        • Split fields
        • Comparing values
        • String values
        • Numeric values
        • Filter rows
      • Sample transformations
    • Mondrian Input
    • MongoDB Input
    • MongoDB Output
    • MQTT Consumer
    • MQTT Producer
    • ORC Input
    • ORC Output
    • Parquet Input
    • Parquet Output
    • Pentaho Reporting Output
    • Python Executor
    • Query HCP
    • Read metadata from HCP
    • Read metadata from Copybook
    • Read Metadata
    • Regex Evaluation
    • Replace in String
    • REST Client
    • Row Denormaliser
    • Row Flattener
    • Row Normaliser
    • S3 CSV Input
    • S3 File Output
    • Salesforce Delete
    • Salesforce Input
    • Salesforce Insert
    • Salesforce Update
    • Salesforce Upsert
    • Select Values
    • Set Field Value
    • Set Field Value to a Constant
    • Simple Mapping (sub-transformation)
    • Single Threader
    • Sort rows
    • Split Fields
    • Splunk Input
    • Splunk Output
    • SSTable Output
    • String Operations
    • Strings cut
    • Switch-Case
    • Table Input
    • Table Output
    • Using Table input to Table output steps with AEL for managed tables in Hive
    • Text File Input
    • Text File Output
    • Transformation Executor
    • Unique Rows
    • Unique Rows (HashSet)
    • User Defined Java Class
    • Write metadata to HCP
    • Write Metadata
    • XML Input Stream (StAX)
    • XML Output
  • PDI job entries
Powered by GitBook
For the complete documentation index, see llms.txt. This page is also available as Markdown.
  1. Pentaho Data Integration
  2. Data Integration
  3. 9.3 Data Integration
  4. PDI transformation steps
  5. Modified Java Script Value

Examples

Check for the existence of fields in a rowAdd a new field in a rowUse NVL in JavaScriptSplit fieldsComparing valuesString valuesNumeric valuesFilter rows
PreviousJavaScript Internal API ObjectsNextCheck for the existence of fields in a row

Last updated 1 year ago

Was this helpful?

LogoLogo

About

  • Pentaho.com

Support

  • Pentaho Support

Resources

  • Privacy

© 2026 Pentaho Software

Was this helpful?