LogoLogo
search
Ctrlk
Try Pentaho! - Start your 30 day evaluation today
  • Pentaho Documentation
  • Pentaho Data Integration 10.2
  • Get started with the PDI clientchevron-right
  • Use a Pentaho Repository in PDIchevron-right
  • Scheduler perspective in the PDI clientchevron-right
  • Streaming analyticschevron-right
  • Data Integration perspective in the PDI clientchevron-right
  • Advanced Pentaho Data Integration topicschevron-right
  • Troubleshooting possible data integration issueschevron-right
  • PDI transformation stepschevron-right
    • Abort
    • Add a Checksum
    • Add sequence
    • AMQP Consumerchevron-right
    • AMQP Producerchevron-right
    • Avro Inputchevron-right
    • Avro Outputchevron-right
    • Calculatorchevron-right
    • Catalog Input
    • Catalog Output
    • Common Formatschevron-right
    • Copybook Inputchevron-right
    • CouchDB Inputchevron-right
    • CSV File Inputchevron-right
    • Data types
    • Deletechevron-right
    • Discover metadata from a text filechevron-right
    • Elasticsearch REST bulk insertchevron-right
    • ETL metadata injectionchevron-right
    • Execute Row SQL Scriptchevron-right
    • Execute SQL Scriptchevron-right
    • Extract to Rowschevron-right
    • File exists (Step)
    • Generate rowschevron-right
    • Get records from streamchevron-right
    • Get rows from resultchevron-right
    • Get System Infochevron-right
    • Google Analytics v4chevron-right
    • Group Bychevron-right
    • Hadoop File Inputchevron-right
    • Hadoop File Outputchevron-right
    • HBase Inputchevron-right
    • HBase Outputchevron-right
    • HBase row decoderchevron-right
    • Hierarchical JSON Inputchevron-right
    • Hierarchical JSON Outputchevron-right
    • Java filterchevron-right
    • JMS Consumerchevron-right
    • JMS Producerchevron-right
    • Job Executorchevron-right
    • JSON Inputchevron-right
    • Kafka consumerchevron-right
    • Kafka Producerchevron-right
    • Kinesis consumerchevron-right
    • Kinesis Producerchevron-right
    • Mappingchevron-right
    • MapReduce Inputchevron-right
    • MapReduce Outputchevron-right
    • Memory Group Bychevron-right
    • Merge rows (diff)chevron-right
    • Microsoft Access inputchevron-right
    • Microsoft Excel Inputchevron-right
    • Microsoft Excel Output
    • Microsoft Excel writerchevron-right
    • Modified Java Script Valuechevron-right
      • General
      • Java script functions pane
      • Java Script panechevron-right
      • JavaScript Internal API Objects
      • Exampleschevron-right
        • 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
    • Modify values from a single rowchevron-right
    • Modify values from grouped rowschevron-right
    • Mondrian Inputchevron-right
    • MongoDB Executechevron-right
    • MongoDB Inputchevron-right
    • MongoDB Outputchevron-right
    • MQTT Consumerchevron-right
    • MQTT Producerchevron-right
    • ORC Inputchevron-right
    • ORC Outputchevron-right
    • Parquet Inputchevron-right
    • Parquet Outputchevron-right
    • Pentaho Reporting Outputchevron-right
    • Python Executorchevron-right
    • Query HCPchevron-right
    • Query metadata from a databasechevron-right
    • Read Metadata
    • Read metadata from Copybookchevron-right
    • Read metadata from HCPchevron-right
    • Regex Evaluationchevron-right
    • Replace in Stringchevron-right
    • REST client stepchevron-right
    • Row Denormaliserchevron-right
    • Row Flattenerchevron-right
    • Row Normaliserchevron-right
    • S3 CSV Inputchevron-right
    • S3 File Outputchevron-right
    • Salesforce bulk operationchevron-right
    • Salesforce Deletechevron-right
    • Salesforce Inputchevron-right
    • Salesforce Insertchevron-right
    • Salesforce Updatechevron-right
    • Salesforce Upsertchevron-right
    • Select Valueschevron-right
    • Set Field Valuechevron-right
    • Set Field Value to a Constantchevron-right
    • Simple Mapping (sub-transformation)chevron-right
    • Single Threaderchevron-right
    • Sort rowschevron-right
    • Split Fieldschevron-right
    • Splunk Inputchevron-right
    • Splunk Outputchevron-right
    • String Operationschevron-right
    • Strings cutchevron-right
    • Switch-Casechevron-right
    • Table Inputchevron-right
    • Table Outputchevron-right
    • Text File Inputchevron-right
    • Text File Outputchevron-right
    • Transformation Executorchevron-right
    • Unique Rowschevron-right
    • Unique Rows (HashSet)chevron-right
    • User Defined Java Classchevron-right
    • Write Metadata
    • Write metadata to HCPchevron-right
    • XML Input Stream (StAX)chevron-right
    • XML Outputchevron-right
  • PDI job entrieschevron-right
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. PDI transformation stepschevron-right
  2. Modified Java Script Value

Examples

Check for the existence of fields in a rowchevron-rightAdd a new field in a rowchevron-rightUse NVL in JavaScriptchevron-rightSplit fieldschevron-rightComparing valueschevron-rightString valueschevron-rightNumeric valueschevron-rightFilter rowschevron-right
PreviousJavaScript Internal API Objectschevron-leftNextCheck for the existence of fields in a rowchevron-right

Last updated 6 months ago

Was this helpful?

LogoLogo

About

  • Pentaho.com

Support

  • Pentaho Support

Resources

  • Privacy

© 2025 Hitachi Vantara LLC

Was this helpful?